View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Macropheliac@yahoo.com is offline
external usenet poster
 
Posts: 8
Default String Font Color VBA

Hello all!

I am wondering how to specify a font color for a string in VBA. For
example, using the following,

aString="Hello World!"
bString="Adios World"
ActiveCell.Value = aString & " " & bString

how would I ammend to make aString Red and Bstring Blue?

Any help is appreciated.

Mac