VBA

Hi Simon

Thanks for your question

Colour can be defined in a number of ways in VBA

VBA colour constants (vbRed, VbGreen etc) are listed in help. Type VBA Colour Constants into the VBE help editor

VBA colour index numbers are listed in file I have attached to this post

The RGB function allows you to specify any colour. The technique here is to open excel, draw and object (Say a circle) and then select colour fill and choose more fill colours and custom. You can then choose the eact colour that you want and enter the three numbers into an RGB function

Regards

Stephen