+ Reply to Thread
Results 1 to 3 of 3

Simple Macro to Change Formatting

  1. #1
    Forum Contributor Saeber4777's Avatar
    Join Date
    06-06-2014
    Location
    United States
    MS-Off Ver
    365 Enterprise
    Posts
    159

    Simple Macro to Change Formatting

    Hello. My question is actually for word, but I figure the vba is the same between word and excel. I'm writing a book in word and I am tired of constantly changing the formatting manually for my body vs. my headers. I need to:

    1. Change the color to RGB(255, 192, 0)
    2. Add bold
    3. Change the font to Calibri light
    4. Add underline
    5. Font size to 14

    I tried running a record macro but it doesn't work very well. It toggles when it should set and it never changes the color of the text.

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,047

    Re: Simple Macro to Change Formatting

    Have you thought about using Styles? That way you can just change the style properties and everything in your document with that style will have those changes applied.

  3. #3
    Forum Contributor Saeber4777's Avatar
    Join Date
    06-06-2014
    Location
    United States
    MS-Off Ver
    365 Enterprise
    Posts
    159

    Re: Simple Macro to Change Formatting

    ByteMarks, I didn't think of that. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Simple changes in macros required
    By Sekars in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2022, 10:31 AM
  2. Simple changes in macros required
    By Sekars in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-17-2022, 04:22 AM
  3. [SOLVED] Change simple add function to macro .
    By I need excel help in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-06-2018, 03:57 PM
  4. [SOLVED] Unable to replicate simple macro process/unable to compose simple copy paste macro
    By MattRNR in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-06-2015, 04:51 AM
  5. [SOLVED] Simple Conditional Formatting change that is not Working
    By endly in forum Excel General
    Replies: 2
    Last Post: 09-13-2015, 06:38 PM
  6. [VBA] Simple Formatting Macro not working?
    By D00kie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-05-2011, 06:31 PM
  7. simple % change macro
    By diesel20056 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-19-2006, 09:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1