Yes, I do see it, and I can type in a value, but the value just disappears
and the field remains empty.
When I code it in the macro, no effect, the list remains empty. Strange.

"Dave Peterson" skrev i melding
...
If you can change the font using the properties, then you should be able
to see
listfillrange. It's about 7 entries below the font on the alphabetic tab.

JimAnAmateur wrote:

I used FormsToolbar first, since there is too little formatting
facilities
on FormsToolbar (e.g., font size), I went over to using Control Toolbox.

So:
1) with FormsToolbar I can specify the row source (as you wrote here),
but
not tthings like font face/size, ...?
2) with Control Toolbox I could change font face/size, but I (so far)
seem
not to be able to specify row source (or ListFillRange).

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






--

Dave Peterson