Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two command butons on an Excel page, both assigned
to the same macro. Let's say the function of the macro is to make the cell to the right of the button blue shade. How can I tell which button was pushed? For example: Sub WhichButton Select Case ButtonPushed.Top Case 100 Range("c10").interior.colorindex = 5 Case <=100 Range("c50").interior.colorindex = 5 End Select End Sub Thanks Daniel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Push button and input box? | Excel Discussion (Misc queries) | |||
Time with the push of one button | New Users to Excel | |||
Push button paste special? | Excel Discussion (Misc queries) | |||
push button paste special | Excel Discussion (Misc queries) | |||
Searching in a row with push on a button | Excel Programming |