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
Microsoft Office