Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello:
I have a userform with 15 command buttons on it. I want to make the color of the command button the same color of the sheet tab. So I have the following code: MyColor = Sheet1.Tab.Color Me.CommandButton1.BackColor = MyColor However, since I have 15 buttons, I would like to write a code that will do it to all command buttons without having to have to write for each command button this code. It looks like there must be an easier way with either a loop, or with... Please help me. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change color of command button | Excel Discussion (Misc queries) | |||
Command Button Color Palette | Excel Programming | |||
Excel Command Button Color | Excel Programming | |||
Command Button Color For Next Loop | Excel Programming | |||
command button color | Excel Programming |