Hi,

I have a cell value contained in cell B6
I have created a combobox called ComboBox1

My question is:
How do I create a macro to check the value of B6 then when I click on the
combobox drop down arrow the combobox autoupdates the list with a range of
C1:C3 to allow selection from the range?

Any help appreciated
Many Thanks

Andy