I am trying to get some textbox values to match a specific textbox value which is in textbox 1. so far I am only getting my combo box to select the desired worksheet and list the index items in the textboxes but they are not matching for the name in textbox 1.

so far this line of code i am working on:
Please Login or Register  to view this content.
I need the ID to match the name in textbox 1. but its no doing that.

The Out come i want happen is that:

1. type in name in textbox 1 then hit search.
2. My listbox populates the names and the sheets in the workbook.
3. Then i would select the sheet name in ComboBox1 so that the macro can serach that sheet and return values for the name in textbox 1 that is on that selected sheet.
4.then if I make changes to a value in one of the textboxes i would like for the change to be made on that selected sheet.

Can anyone help me!!!