<div>
You can't. There is a limited set of VBA named colors and they are vbBlack, vbBlue, vbCyan, vbGreen, vbMagenta, &nbsp;vbRed, &nbsp;vbWhite and vbYellow.
</div>


You can't. There is a limited set of VBA named colors and they are vbBlack, vbBlue, vbCyan, vbGreen, vbMagenta,  vbRed,  vbWhite and vbYellow.

<div>
Thanks! BTW, I know I can create a public declaration of variables accessible in all subs in a given module, but is there a way to define all the color variables in one module such that they will be accessible by all other modules? <br />
<br />
- John
</div>


Thanks! BTW, I know I can create a public declaration of variables accessible in all subs in a given module, but is there a way to define all the color variables in one module such that they will be accessible by all other modules?

- John

<div>
If you declare them Public, they will be accessible to all the modules in the VBA project.
</div>


If you declare them Public, they will be accessible to all the modules in the VBA project.

<div>
<div class="content wysiwyg-content">
Instead of:<br />
cel.Interior.Color &nbsp;= RGB(102, 0, 204)<br />
<br />
I want to say:<br />
cel.Interior.Color = Purple<br />
<br />
How do I write that?<br />
<br />
Thanks,<br />
John
</div>
</div>


Instead of:
cel.Interior.Color  = RGB(102, 0, 204)

I want to say:
cel.Interior.Color = Purple

How do I write that?

Thanks,
John

Identifying a color by name in VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.