View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default combobox question

is it possible to set the list fill range using a range name? or even just a
range?

this doesn't seem to work either,
Me.ComboBox1.ListFillRange = Worksheets("db").Range("b3:ad15")

i wanted to use something like this:
Me.ComboBox1.ListFillRange = rngLU
--


Gary