Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The backcolor of a userform could be any one of 16+ million colours, or are
you looking for system colours. If so search for examples with the GetSysColor API. Regards, Peter T "Abdul" wrote in message ups.com... I found the follwing to get the interior color of a cell How I could get ALL the POSSIBLE Back Color of a userfrom the same way? Sub ListColorIndexes() Dim Ndx As Integer For Ndx = 1 To 56 Cells(Ndx, 1).Interior.ColorIndex = Ndx Cells(Ndx, 2).Value = Ndx Next Ndx End Sub Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UserFrom Back Color | Excel Programming | |||
Match TextBox Back Color to Cell Fill Color | Excel Programming | |||
returning value based on font color-repost | Excel Programming | |||
John Walkenbach Color Palette (Repost) | Excel Programming | |||
Passing Back Color to Interior Color | Excel Programming |