I'm using a List in Data Validation, & the dropdown shows a very small Font
Size, even though after a selection is made, the Font displayed is fine.

Is there a way to "expand" the Font Size in the Dropdown?

TIA - Bob

I've searched - Debra has a workaround...

Thanks - Bob

"Bob Barnes" wrote:

I'm using a List in Data Validation, & the dropdown shows a very small Font
Size, even though after a selection is made, the Font displayed is fine.

Is there a way to "expand" the Font Size in the Dropdown?

TIA - Bob

what was the work around

Also, is it possible to 'type ahead' so when typing P the pick list
will jump to all selections that begin with the letter P


--
breadvan579
------------------------------------------------------------------------
breadvan579's Profile: http://www.excelforum.com/member.php...o&userid=15193
View this thread: http://www.excelforum.com/showthread...hreadid=497772

Debra Dalgleish:
http://contextures.com/xlDataVal08.html#Larger

And not possible using data|validation.

But it is possible with a combobox from the control toolbox toolbar.

breadvan579 wrote:

what was the work around

Also, is it possible to 'type ahead' so when typing P the pick list
will jump to all selections that begin with the letter P

--
breadvan579
------------------------------------------------------------------------
breadvan579's Profile: http://www.excelforum.com/member.php...o&userid=15193
View this thread: http://www.excelforum.com/showthread...hreadid=497772

--

Dave Peterson