LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change font size in formula bar Karen in Wheaton Excel Discussion (Misc queries) 1 August 28th 07 03:02 AM
change font size on screen, but prints in old size lvrcdval Excel Discussion (Misc queries) 2 July 19th 07 02:36 PM
change scaling % but font size didnt change porportionally, pls he Scaling question Excel Discussion (Misc queries) 0 March 12th 07 03:16 AM
Change all text one font size up with various font sizes used. omchrystal New Users to Excel 2 March 6th 07 09:01 PM
Change Font Size Steve Klenner Excel Worksheet Functions 2 November 14th 04 09:34 PM


All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"