Color Index Number

  • Thread starter Thread starter Roger R
  • Start date Start date
R

Roger R

Where would I find all of the numbers associated with the
colors to use while writeing VBA?
 
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)
 
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
 
You must log in or register to reply here.

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

Excel VBA - counting cells by colors and names to it in two different rows. 0
Error Installing "ADAPTEC EZCD 4.04" 1
Excel Numbering rows by font color, but skipping blanks 1
Excel VBA - Problem with Closing Print Preview 0
Run select query from VBA code where criteria comes from a multi select ListBox 2
Youtube is a problem 6
Excel Macro to automatically go to the right of the last colored cell 0
Excel VBA 1

Back
Top