List Box Size....

[Wayne]

I've created a list box in a cell

Data - Data Validation - Allow List


The resulting list box containing many values is teeny
tiny weeny small.

Is there any way the listed information can be shown
larger when the user selects this cell?

Thanks
Inadvance

 

[Debra Dalgleish]

You can't change the font size for a Data Validation dropdown list.
However, you can use programming to adjust the zoom setting when the
cell is selected. There's some sample code here:

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

 

[Wayne]

Thanks Debra, that's just the ticket!!!

-----Original Message-----
You can't change the font size for a Data Validation dropdown list.
However, you can use programming to adjust the zoom setting when the
cell is selected. There's some sample code here:

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


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

.