For color chart: VBA Help search for "PatternColorIndex Property"

To coerce strings to numbers: (re VBA Help "Conversion Functions")

myNum = CInt(myString)

Or

myNum = CLng(myString)

Or

myNum = CDbl(myString)


"WLMPilot" wrote:

1) Where can I find a color chart with numeric values to referece so I can
use BACKCOLOR?

2) I have textboxes that will be accepting numbers. How do I convert the
textbox (string) to a number for placement in cell formated as number?

Thanks,
Les