Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserFrom Back Color
I found the follwing to get the interior color of a cell
How I could get the back color of a userfrom the same way? I mean all the possible colors Thanks 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserFrom Back Color
Abdul wrote:
I found the follwing to get the interior color of a cell How I could get the back color of a userfrom the same way? I mean all the possible colors Thanks 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 Userform1.Backcolor=... -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get the color palette back to the default setting? | Excel Discussion (Misc queries) | |||
We need the old Excel 2203 color palette back | Excel Discussion (Misc queries) | |||
Match TextBox Back Color to Cell Fill Color | Excel Programming | |||
back ground color doesn't work in cell. | Excel Worksheet Functions | |||
Passing Back Color to Interior Color | Excel Programming |