Drop Down list font too small... help please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 14 Apr 2007 13:25 GMT

Hi all,

I have a drop down list - well many actually that are working fine....
except that the values in the drop-down list are literally too amall
to read (at least for me!!!).

The choice selected will display correctly ( font size etc. ) in the
correct cell, but a fter clicking the arow in the cell to access the
drop-down list, the values in that list are approx a font size 8 -
instead of 12. Once chosen the valus appears correctly.

How do I force the displayed font in the drop-down list to be larger?

TIA

Mike

Reply to this Message

Bob Phillips - 14 Apr 2007 13:33 GMT

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

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi all,
>
[quoted text clipped - 12 lines]
>
> Mike

Reply to this Message

Ron Coderre - 14 Apr 2007 13:34 GMT

Debra Dalgleish covers the drop-down list font-size issue on her website:

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

Does that help?
***********
Regards,
Ron

XL2002, WinXP

> Hi all,
>
[quoted text clipped - 12 lines]
>
> Mike

Reply to this Message

Mike - 14 Apr 2007 14:32 GMT

Thanks to all - that is actually very cool ....

IS there a way to get it to return to the default zoom level ---
whatever the user has previously chosen ?

Awesome & quick - thanks

Mike

>Debra Dalgleish covers the drop-down list font-size issue on her website:
>
[quoted text clipped - 23 lines]
>>
>> Mike

Reply to this Message

Don Guillett - 14 Apr 2007 17:36 GMT

oldzoom = ActiveWindow.Zoom
do your thing
activewindow.zoom=oldzoom

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Thanks to all - that is actually very cool ....
>
[quoted text clipped - 32 lines]
>>>
>>> Mike

Reply to this Message

Rate this thread: