Tue 23 Mar 2010, 15:56Delegate Robert said...
Robert has attended:
Excel VBA Intro Intermediate course
Colouring text with VBA
In VBA, I have seen that "vbBlue" can be used to colour text Blue, but "vbPlum" didn't colour text Plum. Is there somewhere where a list of all the options for things like this can be found?
Thanx,
Rob.
Mon 29 Mar 2010, 08:48Trainer Simon said...
RE: colouring text with VBA
Hi Robert,
Thank you for your question.
I have included a link below that outline all the VB constants:
http://msdn.microsoft.com/en-us/library/38cb0hb2 (VS.80).aspx
The other alternative is to use the RGB argument and enter the three values to create your required font colour.
Sub test()
With Range("a1")
.Font.Color = RGB(250, 206, 241)
.Font.Name = "Garamond"
.Font.Size = 18
End With
End Sub
I hope this helps.
Regards
Simon
