Font size in validation list

[Dale Fye]

I've added a validation list to a field in my spreadsheet, but the font size
is a little small. Is there any way to change this?

I thought I saw a message about using a combobox, but am unsure how to
implement that for each column in a spreadsheet.

--
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Pete_UK]

Debra Dalgleish has some notes on techniques here:

http://www.contextures.com/xlDataVal08.html#Font

There is also a link to elsewhere on her site that shows how to do it
with a combo box.

Hope this helps.

Pete

 

[Dale Fye]

Thanks, Pete. That is helping.

One of her instructions is to open the Control Toolbox. How do I do that in
2007? Is that different than the Form toolbox, which is available in the VB
editor?

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Pete_UK]

I don't have XL 2007, so I don't know how it differs from earlier
versions.

Sorry, but maybe someone else can advise...

Pete

 

[Bob I]

Office button, Excel Options, Popular, select Show Developer tab in the
ribbon.
Then click the Developer tab, and Insert in the controls section.

 

[Dale Fye]

When I do this, it offers me Forms controls and ActiveX controls. What is
the difference between these.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Bob I]

Please press F1, look up Forms, click the link that reads

Overview of forms, Form controls, and ActiveX controls on a worksheet