Not sure about your issue, but instead of lookup I use
the ListIndex number to find the information cell.

=======================================
x = Userform1.Listbox1.ListIndex +1

Userform1.TextBox1 = Sheets("MySheet").Cells(x,1)
=====================================

the +1 is because the listindex starts at 0

Cells(x,1) refers to Range("Ax")

--
steveB

Remove "AYN" from email to respond
"MBlake" wrote in message
...
Hi,
Please can anyone assist with a combobox problem?. I just can't figure out
why the following problem is occurring.

User selects a number from a listbox, that number uses vlookup to fill in
four text boxes. Textbox 3 then drives a combobox.

All works well until I make any change to the lookup table, if I change
the text to Capitals or add a new number to the list, then the combobox
only works once a user has selected a specific selection that is number 11
in the list of available numbers.

Everything worked fine for the previous two months, now I am unable to
make any changes to the lookup table and this I must do frequently.

Any ideas would be greatly appreciated as I need desperately to get this
working again.

Thanks,
Mickey