Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I change a macro's font size?
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change font size in formula bar | Excel Discussion (Misc queries) | |||
change font size on screen, but prints in old size | Excel Discussion (Misc queries) | |||
change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
Change all text one font size up with various font sizes used. | New Users to Excel | |||
Change Font Size | Excel Worksheet Functions |