Jim, when you enter the range in the properties box for ListFillRange do it
like this:

a10:c18

No quotation marks, no dollar signs, no spaces, no nothin except the colon
between the range references. The ListBox is automatically tied to the sheet
you create it on so you don't need the sheet1! reference for the range.

For sizing the controls, use the handles that you see when you right click
on them.
Just grab a node with your mouse pointer (cursor) and stretch the control to
the size you want.

"JimAnAmateur" wrote:

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