combo box range

  • Thread starter Thread starter stevieh
  • Start date Start date
S

stevieh

hi,

what is the code so that my combo box lists data that is not hard code
but taken from a range in the sheet?

currently i have this

Private Sub ComboBox1_Change()
ComboBox1.AddItem "england"

but want it to select it from a range i.e a1 to b
 
Combobox.ListFillRange = "A1:B2"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi,

You can do this in your sub:

ComboBox1.AddItem Range("A1").Value
ComboBox1.AddItem Range("A2").Value
ComboBox1.AddItem Range("A3").Value

jeff
 
Back
Top