Combobox Question

[Andy]

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

[Bob Phillips]

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" <a@a.a> wrote in message
news:42e64e30$0$147$7b0f0fd3@mistral.news.newnet.co.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
>
>

[Tom Ogilvy]

If not using xl97, Possibly use the dropdown event.

--
Regards,
Tom Ogilvy

"Andy" <a@a.a> wrote in message
news:42e64e30$0$147$7b0f0fd3@mistral.news.newnet.co.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
>
>