Consulting

Results 1 to 7 of 7

Thread: macro that changes white text in black text

  1. #1

    macro that changes white text in black text

    Is there a macro that searches white text in tables in a document and replaces wihte text in black text?
    Or is there something like it to modify?
    Thank You

  2. #2
    VBAX Contributor
    Joined
    Jul 2020
    Location
    Sun Prairie
    Posts
    123
    Location
    You could use the Replace feature. No macro needed. However, you may, instead, want automatic color instead of black or white.

  3. #3
    Quote Originally Posted by Chas Kenyon View Post
    You could use the Replace feature. No macro needed. However, you may, instead, want automatic color instead of black or white.
    Replace command does not see white text

  4. #4
    VBAX Contributor
    Joined
    Jul 2020
    Location
    Sun Prairie
    Posts
    123
    Location
    Quote Originally Posted by robzane View Post
    Replace command does not see white text
    Yes, it does. If the font is white, that can be picked up. If Replace can't pick it up, neither can vba.
    Again, consider changing everything to Automatic.

    If you want, save a short sample document with the problem and post a link to it. Here's how to do that.
    Why a sample file is important for troubleshooting. How to do it.

  5. #5
    Quote Originally Posted by Chas Kenyon View Post
    Yes, it does. If the font is white, that can be picked up. If Replace can't pick it up, neither can vba.
    Again, consider changing everything to Automatic.

    If you want, save a short sample document with the problem and post a link to it. Here's how to do that.
    Why a sample file is important for troubleshooting. How to do it.
    I do not know words in white so I can't use replace

    I can't understand how to use automatic

    Thank You

  6. #6
    VBAX Contributor
    Joined
    Jul 2020
    Location
    Sun Prairie
    Posts
    123
    Location
    Automatic is a color choice. It is black if the background is light, and white if the background is dark.
    You do not need to know the words, just the color.
    00 deleteme 9.jpg
    You get the color by clicking on More and then under Format picking Font.

  7. #7
    Quote Originally Posted by Chas Kenyon View Post
    Automatic is a color choice. It is black if the background is light, and white if the background is dark.
    You do not need to know the words, just the color.
    00 deleteme 9.jpg
    You get the color by clicking on More and then under Format picking Font.
    Thank You

Posting Permissions

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