Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dan S
 
Posts: n/a
Default Drop down box format

I have a drop down box that works fine but the font size is very small. Is
there a way to increase it w/o also increasing the overall size of the object
so that it's easier to see the list?
  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

If it's a data validation dropdown list, you can't change the font size.
There are a couple of workarounds he

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

If it's a combobox from the Control toolbox, you can change the font
size by switching to Design view, opening the Properties window, and
changing the Font properties.

If it's a combobox from the Forms toolbar, you can't change the font size.


Dan S wrote:
I have a drop down box that works fine but the font size is very small. Is
there a way to increase it w/o also increasing the overall size of the object
so that it's easier to see the list?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formulas for drop down menus Char Excel Discussion (Misc queries) 0 July 18th 05 07:29 PM
data validation list drop down text format too small Bruce Edwards Excel Worksheet Functions 3 May 22nd 05 07:28 PM
Office2000: Conditional format behaves strangely Arvi Laanemets Excel Discussion (Misc queries) 1 April 7th 05 08:47 AM
Date format on a drop down box Steven Cheng Excel Discussion (Misc queries) 6 February 9th 05 03:13 AM
copy conditional format as ACTUAL format Dana Zulager Excel Discussion (Misc queries) 7 December 7th 04 11:02 PM


All times are GMT +1. The time now is 09:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"