Getting a combo/list box to populate based on the other

**niall4488** · 06-14-2011, 05:56 AM

New User here,

Hopefully someone can help me try and sort a problem that my head just can't get around. I have the USer form set up and working etc. However I would like to know how to populate a combo / list box to populate based on the selection in another.

I have a worksheet with 2 colums i.e Column 1 = Report Name, Column 2= How the report is output. So in essence A2 is directly related to B2 and are dependent on nothing else.

I just can't get this working in VBE.

Any help would be greatly appreciated.

Niall

**royUK** · 06-14-2011, 06:00 AM

Try this amended code

Please Login or Register  to view this content.

**niall4488** · 06-14-2011, 06:04 AM

Originally Posted by royUK

Try this amended code

Please Login or Register  to view this content.

RoyUK,

You have sorted in under 1 minute what has taken me days not to find out. Superb and thank you so much for this. Very much appreciated. No doubt I will be back to annoy (consult) you soon.

Super.

Thanks again,

Niall

**royUK** · 06-14-2011, 06:06 AM

Note the different way of loading the ComboBoxes - it's much neater & more efficient

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save