That code clears some cells, but doesn't display dropdown lists.

If you increase the zoom setting in the worksheet, the font will appear
larger. Then your friend may be able to increase the font size later,
depending on what type of dropdown list was used.

dave60610 wrote:
A friend created a macro for me that allows a user to use a drop-down box to
select an item from among a previous field of choices. Unfortunately, the
font in the drop-down boxes is tiny, and my friend is out of the country,
away from a computer for two weeks.

This spreadsheet contains a few dozen such macros. Does anyone know how I
would increase the font size in the drop-down box macros? Also, is there any
way to change the font size in all macros at once, or would I have to go one
by one, changing each?

Here's a sample of one of the macros' code:

'
Range("C5:G66").Select
Selection.ClearContents
Range("H39").Select
Selection.ClearContents
Range("I36").Select
Selection.ClearContents
Range("I5:M66").Select
Selection.ClearContents
End Sub

Thanks in advance for your help!


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