Coza,

I don't find ControlTollbox. I am using Excel 2003.
Where do I find it?

br Jim

"JLGWhiz" skrev i melding
...
Jim, If you use the Control Toolbox to create your combo box, you will
need
to be in design mode to access the properties box. Otherwise you can use
the
AddItem or List method to fill the box.

If you use the Forms Toolbar to create the combo box then you will need to
use the format control option on the Forms toolbar and on the Control tab
you
can specify the range for the row source and links.

"JimAnAmateur" wrote:

Thanks, Nick!

But, no matter what I write (in the field "ListFillRange"), it's just not
recorded (the field gets empty right away).
What is the syntax for this field? I tried e.g. "Sheet1!a1:a10" (with and
without quotation marks), ...

br Jim

"Nick Hodge" skrev i melding
...
Jim

It's ListFillRange on the ActiveX control in Excel. The difference is
because UserForms are part of Office rather than specific to Excel

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"JimAnAmateur" wrote in message
...
Strange: When I draw a ComboBox on a UserForm, I can specify RowSource
for this control (to let it read data from a given range in a
worksheet).
However, when I draw a ComboBox directly in a worksheet, I don't see
RowSource in the Properties-window.

What's wrong? Any suggestions?

br Jim