+ Reply to Thread
Results 1 to 4 of 4

Find and Replace text with new text but make it bold

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,662

    Find and Replace text with new text but make it bold

    Hi,

    I have a need to find and replace text but the new text should be bold?

    i am using the "Replace" function in vba to replace the text once found. But i am not sure how to make the text bold.

    Here is the replace function in vba:
    Replace(allcharofoldstring, textinoldstringtoreplace,newstringtoreplace)

    any thoughts?

    FYI: i did try making the "textinoldstringtoreplace" bold but this did not work.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: Find and Replace text with new text but make it bold

    Hi,

    Does this work for you?

    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Find and Replace text with new text but make it bold

    .
    Please Login or Register  to view this content.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Find and Replace text with new text but make it bold

    .
    Sweep :


    Morse.jpg
    Last edited by Logit; 12-16-2020 at 01:18 PM.

+ 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. VBA to make text Bold
    By shivshanakar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2020, 11:02 AM
  2. Replace 'Bold' text with '(Bold)' text
    By thebigbopper in forum Excel General
    Replies: 8
    Last Post: 04-19-2017, 01:44 AM
  3. [SOLVED] How to make part of the text in a cell bold
    By aymanzone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2012, 05:26 AM
  4. How to make some text in a Cell Bold?
    By v2jtb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2012, 11:00 AM
  5. find in excel replace in word: find/replace text in text boxes and headers
    By dean.rogers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2012, 12:40 PM
  6. make text dependant on cell - Bold
    By stevecontracts in forum Excel General
    Replies: 3
    Last Post: 02-18-2010, 04:50 AM
  7. Need to make certain text bold in a comment using vba
    By Bravurian17 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2009, 11:58 PM

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