Nick,

I did as you describe, but still, the field returned empty right away.
I also did it in macro, e.g. ComboBox1.ListFillRange = "Sheet1!$A$1:$A$10",
and it didn't work either (the list remains empty).

More problems: ActiveX controls that I add on my sheet (TreeView,
RichTextBox), no matter how I specify the size (both in properties-windows,
and programmed in macro), they appaer as a little window (not the size I
specified) on the sheet when I reopen the file. I do have a Sub that is
called in Auto_Open, and that "re-draws" the controls on the sheet, but the
controls remains "tiny" on the sheet.

br Jim

"Nick Hodge" skrev i melding
...
Jim

In the property enter

Sheet1!$A$1:$A$10

No quotes but you need the absolute reference
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"JimAnAmateur" wrote in message
...
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