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

Don't understand the relationship between B6 and C1:C3.

basic code is

Private Sub ComboBox1_DropButtonClick()
ComboBox1.ListFillRange = "c1:c6"
End Sub

--
HTH

Bob Phillips

"Andy" wrote in message
o.uk...
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

If not using xl97, Possibly use the dropdown event.

--
Regards,
Tom Ogilvy

"Andy" wrote in message
o.uk...
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