View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Alan Alan is offline
external usenet poster
 
Posts: 138
Default 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.