ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formatting drop down list (https://www.excelbanter.com/excel-discussion-misc-queries/3529-formatting-drop-down-list.html)

dennis

formatting drop down list
 
I have created a drop dopwn list but the list is too small to read How do I
formatt the drop down list to increase the size of the font on the list

JulieD

Hi Dennis

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

for the unhappy news that this can't be changed .. however, a work-around is
provided, which you may find useful.

Cheers
JulieD

"dennis" wrote in message
...
I have created a drop dopwn list but the list is too small to read How do I
formatt the drop down list to increase the size of the font on the list




Peo Sjoblom

If you use a combobox from the control toolbox you can change the font size,
if you are using dataavlidation you cannot, one possible workaround

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


Regards,

Peo Sjoblom

"dennis" wrote:

I have created a drop dopwn list but the list is too small to read How do I
formatt the drop down list to increase the size of the font on the list



All times are GMT +1. The time now is 11:54 AM.

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