ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Font size in validation list (https://www.excelbanter.com/excel-discussion-misc-queries/197755-font-size-validation-list.html)

Dale Fye

Font size in validation list
 
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

Font size in validation list
 
Debra Dalgleish has some notes on techniques he

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

On Aug 6, 1:03*pm, Dale Fye wrote:
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.



Dale Fye

Font size in validation list
 
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" wrote:

Debra Dalgleish has some notes on techniques he

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

On Aug 6, 1:03 pm, Dale Fye wrote:
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

Font size in validation list
 
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

On Aug 6, 2:50*pm, Dale Fye wrote:
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!


Bob I

Font size in validation list
 
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 wrote:

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?



Dale Fye

Font size in validation list
 
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" wrote:

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 wrote:

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?




Bob I

Font size in validation list
 
Please press F1, look up Forms, click the link that reads

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


Dale Fye wrote:

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




All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com