Formatting text in a data validation drop-down

  • Thread starter Thread starter Bob U
  • Start date Start date
B

Bob U

I'm trying to use a data validation drop-down (in Excel
2000)to select valid entries from a range of cells.

My problem is that the text in the drop-down list is
extremely small, almost unreadable, and I can find no way
to change the text formatting inside the drop-down.

Once an item is selected and appears in the cell, standard
formatting techniques work, but before the selection is
made I can't influence the size.

Anyone know how to do this, or if it is possible?
 
I've run into this in the past. I don't believe you can control the look of
the list if you are using the Data Validation function. However, if you use
an ActiveX control, you will have more control.

- John Michl
www.JohnMichl.com
 
The workaround is to select the drop down list, increase the zoom setting,
choose from the drop down list, then return to the regular zoom setting.

This is usually accomplished with the use of code (macros).

Check out this site of Debra Dalgleish's for a procedure.

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I'm trying to use a data validation drop-down (in Excel
2000)to select valid entries from a range of cells.

My problem is that the text in the drop-down list is
extremely small, almost unreadable, and I can find no way
to change the text formatting inside the drop-down.

Once an item is selected and appears in the cell, standard
formatting techniques work, but before the selection is
made I can't influence the size.

Anyone know how to do this, or if it is possible?
 
Thanks for the help. It's a little awkward, but it works.
I used her code titled "Zoom in when any cell with data
validation is selected" since I have a lot of validated
columns but added code to zoom back once the selection was
made, so it's somewhat more usable.
 
Back
Top