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" wrote in message
...
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" wrote in message
...
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
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