Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Change Font size in Excel VBA

hi there, I want to change the font size using a macro, if
theres a way pls help me with this.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Change Font size in Excel VBA

Range("C3").Font.Size = 12

You can find out the answers to questions like these by recording
macro while doing it manually and then perusing the code generated.



--
Message posted from http://www.ExcelForum.com

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Change Font size in Excel VBA

activecell.Font.Size = 14

--
Regards,
Tom Ogilvy

"George" wrote in message
...
hi there, I want to change the font size using a macro, if
theres a way pls help me with this.



Reply
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
how do I change default font type/size in excel? JSF Setting up and Configuration of Excel 6 May 4th 09 02:07 PM
Change all text one font size up with various font sizes used. omchrystal New Users to Excel 2 March 6th 07 09:01 PM
How do I change the font size of a pull down menu in MS Excel sizeit Excel Worksheet Functions 1 July 17th 06 10:49 PM
How can I change the font size on an Excel sheet tab? Inobugs Excel Discussion (Misc queries) 3 October 26th 05 10:58 AM
Change default font and size in Comments box in Excel. ArtieF Setting up and Configuration of Excel 3 September 19th 05 05:27 PM


All times are GMT +1. The time now is 02:23 PM.

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

About Us

"It's about Microsoft Excel"