Results 1 to 2 of 2

Thread: Setting part of text in excel cell to bold - (SOLVED)

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Aug 2002
    Location
    The 'natti
    Posts
    27

    Setting part of text in excel cell to bold - (SOLVED)

    I'm creating an excel worksheet in VB and I have a line of text in a cell and only part of that text should be bold.

    Setting the font objects bold property to true or false affects the entire value property.

    I've tried putting the text in two separate cells and merging, but only value of the first cell is retained.

    Here is the desired output:
    Delivered: Any project that has Phase 3 Actual Exit Date filled


    Any tips are greatly appreciated.
    Last edited by bubba; Aug 28th, 2002 at 08:40 AM.

  2. #2

    Thread Starter
    Junior Member
    Join Date
    Aug 2002
    Location
    The 'natti
    Posts
    27
    As usual, after I ask for help, I figure out the solution. If anyone is interested:

    oWsOne.Range("A" & CStr(iCurRow)).Select
    ActiveCell.Value = "Released: Any project that has Phase 3 Actual Exit Date filled"

    With ActiveCell.Characters(Start:=1, Length:=10).Font
    .Bold = True
    .Size = 8
    End With
    With ActiveCell.Characters(Start:=11, Length:=53).Font
    .Bold = False
    .Size = 8
    End With
    Last edited by bubba; Aug 28th, 2002 at 08:45 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width