|
-
Aug 28th, 2002, 08:13 AM
#1
Thread Starter
Junior Member
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.
-
Aug 28th, 2002, 08:41 AM
#2
Thread Starter
Junior Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|