+ Reply to Thread
Results 1 to 4 of 4

How to make part of the text in a cell bold

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    dubai
    MS-Off Ver
    Excel 2003
    Posts
    6

    How to make part of the text in a cell bold

    I want "some" of the text in my cells to be bold. I'm tried both these codes bellow

    Workbooks("AH responsible Macro Enabled").Worksheets("testSheet").Cells(i, 1).Characters(7, 5).Font.Bold = True

    Workbooks("AH responsible Macro Enabled").Worksheets("testSheet").Cells(i, 1).Characters(7, 5).Font.FontStyle = "Bold"

    Instead all my cells are coming in bold. why? The text inside the cells is: Hello There, How are you doing? I'm doing fine this is a test.

    After I run the code i think it should read: Hello There, How are you doing? I'm doing fine this is a test.

    Anyways, I'm wondering why the whole cell is coming in bold. I'm really confused.

    Edit: Using Excal 2010 and VBA 7.0 for Excel

    Thanks.

    ---------- Post added at 11:49 AM ---------- Previous post was at 11:42 AM ----------

    I think I know why.

    previously I use this code which I commented out:

    Workbooks("AH responsible Macro Enabled").Worksheets("testSheet").Cells(i, 1).Font.Bold = True


    I just went into excel sheet and removed the Bold setting.
    Last edited by aymanzone; 08-14-2012 at 03:46 AM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: How to make part of the text in a cell bold

    Am glad you solved it on your own.

    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to make part of the text in a cell bold

    It works for me.
    Does your last comment mean the request has bee solved? In which case would you mark it as solved so that others don't waste time.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    08-13-2012
    Location
    dubai
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: How to make part of the text in a cell bold

    Yes, done it now. Wasn't aware of how to set to solved.

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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