Combobox Question
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
|