Where can I find a color chart to reference when programming in VBA? I need
to program BACKCOLOR.RGB for various textboxes, but I do not know the numbers
to enter.

Thanks,
Les

What I do is color the control in the VB Editor window using the Palette
dropdown thingie in the Properties pane, then see what hex number is
inserted into the Backcolor property box. This can be copied and pasted into
your code.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"WLMPilot" <(E-Mail Removed)> wrote in message
newsF17E955-C907-40E9-8F0B-(E-Mail Removed)...
> Where can I find a color chart to reference when programming in VBA? I
> need
> to program BACKCOLOR.RGB for various textboxes, but I do not know the
> numbers
> to enter.
>
> Thanks,
> Les

On worksheet Turn on Tools - Macro - Record Macro. Then select colors that
you like. Stop recording and get the numbers from the recorded macro.

"WLMPilot" wrote:

> Where can I find a color chart to reference when programming in VBA? I need
> to program BACKCOLOR.RGB for various textboxes, but I do not know the numbers
> to enter.
>
> Thanks,
> Les

Kind of along similar lines to Jon's suggestion, add a shape to the sheet,
Format/Colors & Lines/ Fill - More colours.

'Make' your desired colour and under the custom colour-picker grab the RGB
values.

Regards,
Peter T

"WLMPilot" <(E-Mail Removed)> wrote in message
newsF17E955-C907-40E9-8F0B-(E-Mail Removed)...
> Where can I find a color chart to reference when programming in VBA? I
need
> to program BACKCOLOR.RGB for various textboxes, but I do not know the
numbers
> to enter.
>
> Thanks,
> Les

See David McRitchie's site for answers on the color palette.

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


Gord Dibben MS Excel MVP

On Fri, 11 Jan 2008 04:42:02 -0800, WLMPilot
<(E-Mail Removed)> wrote:

>Where can I find a color chart to reference when programming in VBA? I need
>to program BACKCOLOR.RGB for various textboxes, but I do not know the numbers
>to enter.
>
>Thanks,
>Les