Color Chart

[WLMPilot]

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

 

[Jon Peltier]

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

 

[Joel]

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

 

[Peter T]

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

 

[Gord Dibben]

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

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


Gord Dibben MS Excel MVP