Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA
Resolved · Low Priority · Version 2003
Reply Mon 29 Jun 2009, 16:54Delegate Simon said...
Simon has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
VBA
Where can I get the list of codes for the various format colours in excel and vba?
For upcoming training course dates see: Pricing & availability
RE: 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
Attached files...
Number Index Table.xlsTue 7 Jul 2009: Automatically marked as resolved.
|