View Full Version : Help: HOw many color is there in Excel
yurble_vn
09-08-2007, 11:57 AM
I read some where that excel have 56 color index.
But when count in color palette, I just see 5*8=40 color. SO, where is the rest?
mdmackillop
09-08-2007, 12:48 PM
Sub ShowColours()
Dim i As Long
For i = 1 To 56
Cells(i, 1).Interior.ColorIndex = i
Next
End Sub
yurble_vn
09-08-2007, 07:01 PM
Thanks Mackillop,
Just run it
BTW, What is the rule to index color in Color Palette ? I cant find out the rule
enfantter
09-09-2007, 05:50 AM
i also have less colors for the palette in vba, when fx i wanna do userform
or if i just wanna do a button
Bob Phillips
09-10-2007, 01:01 AM
Many of them are repeated, but you can override those repetitrions with custom colours.
You can see them all under Tools-Options-Color.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.