Beginner: List of Color Values

26 Feb 2007 5:16 PM

redruthann

I mostly create everyday macros. I've learned how to revise them and create
new ones based on previous macros.

This is probably a silly question, but is there a list or chart that has all
of the available color values? Not the RGB, but more of the basic.

For example, I want to change a color of a fill in a macro - but I don't
know what the values are...15, 11, 19 etc. Right now, I create a macro using
the color I want and then go into Visual Basic and copy that value into the
other one.

Thanks for any help,

Ruth

26 Feb 2007 5:46 PM

Bob Butler

"redruthann" <redruth***@discussions.microsoft.com> wrote in message
news:89249385-B6B0-4256-8D5C-A123B4A94B0F@microsoft.com
> I mostly create everyday macros. I've learned how to revise them and
> create new ones based on previous macros.
>
> This is probably a silly question, but is there a list or chart that
> has all of the available color values? Not the RGB, but more of the
> basic.
>
> For example, I want to change a color of a fill in a macro - but I
> don't know what the values are...15, 11, 19 etc. Right now, I create
> a macro using the color I want and then go into Visual Basic and copy
> that value into the other one.

It sounds like you are talking about VBA in Excel (or some other
application), not VB. You'd probably do better asking in an Excel VBA
newsgroup as the two languages may overlap but are not the same and Excel's
colors are specific to Excel.

Dim x As Long
For x = 1 To 56
Sheet1.Cells(x, 1) = x
Sheet1.Cells(x, 1).Interior.ColorIndex = x
Next

--
Reply to the group so all can participate
VB.Net: "Fool me once..."

26 Feb 2007 5:58 PM

redruthann

Thank You You are absolutely correct.

Sorry about that

Ruth

Show quoteHide quote

"Bob Butler" wrote:

> "redruthann" <redruth***@discussions.microsoft.com> wrote in message
> news:89249385-B6B0-4256-8D5C-A123B4A94B0F@microsoft.com
> > I mostly create everyday macros. I've learned how to revise them and
> > create new ones based on previous macros.
> >
> > This is probably a silly question, but is there a list or chart that
> > has all of the available color values? Not the RGB, but more of the
> > basic.
> >
> > For example, I want to change a color of a fill in a macro - but I
> > don't know what the values are...15, 11, 19 etc. Right now, I create
> > a macro using the color I want and then go into Visual Basic and copy
> > that value into the other one.
>
> It sounds like you are talking about VBA in Excel (or some other
> application), not VB. You'd probably do better asking in an Excel VBA
> newsgroup as the two languages may overlap but are not the same and Excel's
> colors are specific to Excel.
>
> Dim x As Long
> For x = 1 To 56
> Sheet1.Cells(x, 1) = x
> Sheet1.Cells(x, 1).Interior.ColorIndex = x
> Next
>
>
> --
> Reply to the group so all can participate
> VB.Net: "Fool me once..."
>
>

26 Feb 2007 6:06 PM

redruthann

Thanks again. I found it right away.
Just figured I put the site in - in case someone else like me comes in.

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

Show quoteHide quote

"Bob Butler" wrote:

> "redruthann" <redruth***@discussions.microsoft.com> wrote in message
> news:89249385-B6B0-4256-8D5C-A123B4A94B0F@microsoft.com
> > I mostly create everyday macros. I've learned how to revise them and
> > create new ones based on previous macros.
> >
> > This is probably a silly question, but is there a list or chart that
> > has all of the available color values? Not the RGB, but more of the
> > basic.
> >
> > For example, I want to change a color of a fill in a macro - but I
> > don't know what the values are...15, 11, 19 etc. Right now, I create
> > a macro using the color I want and then go into Visual Basic and copy
> > that value into the other one.
>
> It sounds like you are talking about VBA in Excel (or some other
> application), not VB. You'd probably do better asking in an Excel VBA
> newsgroup as the two languages may overlap but are not the same and Excel's
> colors are specific to Excel.
>
> Dim x As Long
> For x = 1 To 56
> Sheet1.Cells(x, 1) = x
> Sheet1.Cells(x, 1).Interior.ColorIndex = x
> Next
>
>
> --
> Reply to the group so all can participate
> VB.Net: "Fool me once..."
>
>