Format text using VBA
 

Is it possible to embolden part of the text held in a cell using VBA?

For example, if a cell contains two words " dog cat" is it possible to
change the font of "dog" to bold without changing the attributes of
"cat"?

Alan

Format text using VBA
 

With ActiveCell

.Characters(5, 3).Font.Bold = True
End With


--
__________________________________
HTH

Bob

"Alan" wrote in message
...
Is it possible to embolden part of the text held in a cell using VBA?

For example, if a cell contains two words " dog cat" is it possible to
change the font of "dog" to bold without changing the attributes of
"cat"?

Alan

Format text using VBA
 

On 30 Apr, 09:57, "Bob Phillips" wrote:
* * With ActiveCell

* * * * .Characters(5, 3).Font.Bold = True
* * End With

--
__________________________________
HTH

Bob

"Alan" wrote in message

...



Is it possible to embolden part of the text held in a cell using VBA?

For example, if a cell contains two words " dog cat" is it possible to
change the font of "dog" to bold without changing the attributes of
"cat"?

Alan- Hide quoted text -

- Show quoted text -

Thanks Bob, that is a great help.