Yep. You can use a list for each type (data|validation and a combobox from the
control toolbox toolbar).

For the data|validation, take a look at Debra Dalgleish's site:
http://contextures.com/xlDataVal01.html
(a nice place to start)

For the combobox from the control toolbox.
Show that toolbar
click on the design mode (just like changing the font)

Look for ListFillRange and type your range's address there.
'sheet 2'!a1:A9
for example

Look for linkedcell if you want a, er, linked cell.


rmellison wrote:

I'm using a dropdown list from the forms toolbar. That'll be why I can't
change the font!

The reason I'm using the combobox from the forms toolbar is that I'm not
sure how to set-up a control combo box to show a list from a cell range. In
the Format Control option it doesn't have the 'control' tab, unlike for a
forms tool. I should imagine there's a way to do it, but haven't figured that
out yet. Does involve some VBA magic?

Similarly, I just tried messing around with Data | Validation and didn't get
very far. Can this be used to represent a dropdown list for a given cell
range as well?

"Dave Peterson" wrote:

Is it a combobox from the control toolbox toolbar on a worksheet? Or is it a
combobox in a userform?

If it's on a worksheet, show the control toolbox toolbar.
click on the design mode icon
rightclick on the combobox
select properties and look for font
and double click on it.
(don't forget to leave design mode when you're done.)

Just rightclick on that combobox
choose properties
and double click on Font
(very similar)

=======
If you used data|Validation or the dropdown from the Forms toolbar, then you
can't change the font size.

But Debra Dalgleish has a workaround for Data|Validation at:
http://contextures.com/xlDataVal08.html#Font

rmellison wrote:

How do you edit the font size etc in a combo box form?

--

Dave Peterson


--

Dave Peterson