Failed tp activate range with listbox item select

[tlchan]

Hi there,
What I want to accomplish on the click listbox1 event is when item in listbox selected the respective record will shown on textbox for further amendment.

However the problem i facing is the pointer does not select at the respective range for upte resulting the amendment was wrongly updated to other record instead. Error highlight at
"Range(strRangeAddress).Activate"

Attached the workbook

[Kenneth Hobs]

When I put Jack in, it said there were 2 but showed nothing in the listbox. Were the 2 records found supposed to be in the listbox?

[tlchan]

The listbox will display the find result if more than 1 record was found. Msg will prompt there are more than 1 record found. User to click FIND ALL button to display the result in the listbox. Thereafter select the item in the listbox for amendment or display in the textbox.


The problem is when the list item is selected the item does not display at the textbox for amendment into worksheet record.:dunno