populate userform listbox from textbox input

hi
my userform3 has textbox and a listbox as i enter number in textbox it populates listbox but not with highlighted rows though,think it has something to do with range but have tried many changes and can not get right,any ideas please
cheers colin

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.

Colin

Here you go, this replaces all the code for UserForm3.

It's not quite complete as I've not added code to set the widths of the columns in the listbox, I just set it's ColumnCount to 3.

Please Login or Register  to view this content.

PS I've also used something kind of new, to me anyway, to find the rows matching the selected ID. It seems to have worked, but the code can always
be changed back to use another method.

The code is there to populate the other columns.

Did you change the ColumnCount of the listbox like I did?