View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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