Colin

Where are you trying to populate the listbox from? It appears to be a range with only 3 cells, A3, C3 and E3.

By the way, have you considered using a combobox instead of a textbox?

It could list all the unique codes/IDs/things, whatever it is that the user is mean to enter.

The reason I suggest that is because the textbox change event is triggered after every keystroke.

So, for example, if I enter ST0200 the code will have been executed 5 times before I've entered in the full code.

With a combobox you can add code to see if the user has selected or typed a value on the list, and if they have run the code to populate the listbox.