Excel 2003: Worksheet cells populate textboxes on a userform

[SHU_STU_0609]

Hi,

I'm looking for some vba code that will lookup a reference number entered into a text box on a userform, goto a worksheet with the reference number coloum and stored data in, and then populate the assigned textboxes on the userform with the stored data for that reference number.

I've actually found some code from within this forum posted previously, but the code wasn't taking the entered value and searching it against a specific column in a worksheet, just looking for the instance of that value across the entire sheet, which meant the results where varied.

What would the code be in VBA to make it take an entered value in a textbox in a userform and to search it against a specific column in a worksheet, and then begin to take values from cells to the left to populate the textboxes on the userform?

Edition of Excel using is 2003.

Thanks in advance for any help.

Regards

Tom

[djbomaha]

Hi,

I have attached a workbook that gives an example of a user form that populates from a worksheet and then updates as reference numbers are change. In the example, if any of the fields change, all the other cells in the user form are updated. To initialize the macro to see the user form, press "<CTRL> a".

Thanks,

Daniel

[SHU_STU_0609]

Thank you for your reply, that sample spreadsheet works brilliant.

But I could do with coding that specifically just retrieves data on a single textbox1.value, rather then the option of multiple comboboxes.

So it just:
A. Click on a cmd button looks at a value in a textbox
B. Then using this value looks in a specific coloum in a worksheet
C. Then retrieves the data from the corresponding cells to the right in the worksheet, to populate the textboxes on the userform

?

[djbomaha]

Hi,

Are you trying to pull data from a "textbox" or a "listbox"? A Listbox looks like a combobox without the dropdown arrow and you can just type in text. A "textbox" is used as headers on the user form typically and the user can't use them to input information. They can be changed, but there is no ability to use them for input. Do you have a file you can post that shows what you are trying to do? I used Excel 2003, so if you have one it needs to be saved in that version for me to be able to open it.

Thanks,

Dan