I want to populate a listbox with a combobox selected item.

**Bailers** · 07-11-2014, 04:59 AM

I am a total newbie to this type of thing. So play nice

I have created a combobox which I have populated with a unique list (PartCode).
When I select the required item from the combobox I want to search the entire worksheet and popoulate the listbox with a list of all the enters with that selected part code.

The worksheet has over 200 columns and over 2000 rows!!

**HaHoBe** · 07-11-2014, 05:43 AM

Hi, Bailers,

maybe attach a samplke workbook ion order for us to get more information what to program.

In the meantime you may have a look at An Excel DatabaseForm to adapt for your own projects and see if you may adapt the concept to suit your needs.

Ciao,
Holger

**Bailers** · 07-11-2014, 06:28 AM

Thanks for the reply.

I have attached the following workbook.

**HaHoBe** · 07-11-2014, 06:42 AM

Hi, Bailers,

you would need to add what information should be displayed in the Listbox (as I doubt it to be any good idea to incorperate Columns up to FY in a Listbox, and I even more doubt it to be technically desirable to do so).

Again: have a look at the sample Database I mentioned. All the basic code should be on hand, you would need to update the ranges and the arrays to suit.

Ciao,
Holger