View Single Post
  #4   Report Post  
rmellison
 
Posts: n/a
Default

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