Excel 2003

[Alefiah]

I have a user who has got a couple of embedded drop down list boxes on her
spreadsheet, the problem is she can hardly read the entries. Is there a way
to change the font size so the values in the cell are bigger.

 

[Gary''s Student]

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

 

[Alefiah]

Thank you for the link. I tried everything that was stated in there but it
still does not work. I did not have any luck with changing the font size.

 

[Gord Dibben]

You did not "try everything" because the method you were pointed to does
work as advertised.

You have done something incorrectly in creating the combo-box or placement
of the code.

Did you download the sample workbook to see it in action?

Link to that is at bottom of the page.

Maybe you could try this alternate method from Debra's site that changes
Zoom setting when the DV cell is clicked.

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


Gord Dibben MS Excel MVP