+ Reply to Thread
Results 1 to 3 of 3

how do i make certain words bold?

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    San Francisco, USA
    MS-Off Ver
    Excel 2007
    Posts
    60

    how do i make certain words bold?

    in A1 using vba i would to do:

    john is strong

    cells(1,1) = ?

    thanks

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: how do i make certain words bold?

    The syntax looks like this
    Starting character position, and then how many characters you want to highlight as bold.

    ActiveCell.Characters(9, 6).Font.Bold = True

  3. #3
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: how do i make certain words bold?

    Please Login or Register  to view this content.
    then activate macro recorder, select the word and make it strong, stop macro recorder and see the code
    If solved remember to mark Thread as solved

+ 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. Replies: 7
    Last Post: 06-05-2014, 02:50 AM
  2. Search and Replace words in bold
    By moochie in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-28-2012, 03:56 PM
  3. how can I make this BOLD?
    By Mamud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2012, 06:15 AM
  4. [SOLVED] A macro that will underline, bold, and change to red color text individual words.....
    By beepbeep27 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2012, 01:48 PM
  5. [SOLVED] Help to edit (bold, colour etc) words in a text box created by control toolbox
    By Jonathan hill via OfficeKB.com in forum Excel General
    Replies: 1
    Last Post: 02-12-2005, 09:06 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