populate ListBox with data from worksheet based on match from TextBox text

JohnsonK · Oct 13th 2020

Hi,

I have a userform with a textbox, two comboboxes and a ListBox, from the first combobox the user selects either IN or OUT then enter a code in the textbox then selects a qty from the other combobox, what I am trying to do is from the code they enter in the textbox for it to then search a worksheet called Data for a match and then populate that row of data in to the listbox. I have attached a mock up of the worksheet with userform if it will help.

**royUK** · Oct 14th 2020

You have added values manually using the controls' Properties.

Your question makes no sense, what exactly are you aiming to do?

**royUK** · Oct 14th 2020

I think this is basically what you want. It will need some error handling adding.

I would say that this would be much better handled using formulas not VBA, it would need another sheet to record inputs and outputs

Share