Color Index Number

R

Roger R

Where would I find all of the numbers associated with the
colors to use while writeing VBA?
 
B

Bob Phillips

Look for ColorIndex property in VBA Help

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

Gord Dibben

Roger

Sub ListColorIndexes()
Dim Ndx As Long
Sheets.Add
For Ndx = 1 To 56
Cells(Ndx, 1).Interior.ColorIndex = Ndx
Cells(Ndx, 2).Value = Hex(ThisWorkbook.Colors(Ndx))
Cells(Ndx, 3).Value = Ndx
Next Ndx
End Sub

Also see David McRitchie's site for more on the color palette

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

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing from Word my Inserted Pictures colors are dull and lack color 0
Need help modifying code 0
Match table shading (color) to Visio color/Transparency 1
Autonumber field in Excel that behaves the same as Access 0
How do I convert shading to highlighting for specific colors 8
Using Flags with Resource Percentages 0
Layout Guide color 0
Create Index using VBA in Publisher 2007 0

Top