colour index from F1 in VBA

[Paula Office]

Hello,

In 2000 in the VBE window you could press F1 in a piece of code and see a list of the colours available with the relevant colour code. I can't seem to do this anymore. After a bit of searching I am still none the wiser.

Can anyone tell me if there is a list anywhere?

Thanks

 

[Trevor G]

Do you mean how you can use the Interior or Font Color options and what they are. Some options you can refer to vbColor such as

Range("A2").Interior.Color = vbRed
Range("A2").Interior.Color = vbBlue
Range("A2").Interior.Color = vbGreen
Range("A2").Interior.Color = vbCyan
Range("A2").Interior.Color = vbYellow
Range("A2").Interior.Color = vbWhite

Other methods you would use the ColorIndex method

Range("A2").Interior.ColorIndex = 3
Range("A2").Interior.ColorIndex = 4

Or using the RGB method

So I assume you want the ColorIndex method or RGB

Here is a link to one of many website that will help you

http://dmcritchie.mvps.org/excel/colors.htm

 

[Paula Office]

Thank you for your response, I wasn't sure what grouping they were previously only that you could press F1 in the word colourindex and get a colour pallet appear. However, the first list you have described will be fine for what I have in mind.

Thank you once again.