Define Range for Combo Box

  • Thread starter Thread starter gregork
  • Start date Start date
G

gregork

Is it possible to define a cell range for a combo box list on a user form.
If yes then how would you write the code ? I know I could list with .AddItem
"" but I have a possible list of 200 entries so I'm looking for a shortcut.

regards
GregK
 
Firstly, name your array

ComboBox1.List = Range("a").Value

e.g. assumes "a" is the named array
 
Greg,

Set the RowSource property to the range.

--

HTH

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