View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Control ToolBox ComboBox

You have the correct property - in the box to the right of the property type
A1:A10 and press enter.

You can also populate a combo box via code but it may be simplier to use a
spreadsheet range.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Steve D" wrote:

I am looking for the format of entering the list in the properties of a
combobox (Control ToolBox). Would I enter the range in the "ListFillRange"
Property? If so, how do I enter it to refer to a different sheet (what is the
text?)
--
Thank You,
Steve