Colouring text with VBA

Resolved · Low Priority · Version 2003

Tue 23 Mar 2010, 15:56 Delegate 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:48 Trainer 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