Dropdown Font Size

[Bob Barnes]

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

 

[Bob Barnes]

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

Thanks - Bob

 

[breadvan579]

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

 

[Dave Peterson]

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.