Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Subs,
If it's a button on a worksheet from the forms toolbar then Application.Caller returns the button's name. If you want to identify the button using its caption eg "Start" then try: Dim WhichButton as Shape Set WhichButton = ActiveSheet.Shapes(Application.Caller) If WhichButton.TextFrame.Characters.Text = "Start" then do something.. Other than that I really don't know. I mainly work on a Mac so I know nothing about ActiveX controls. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Do until button clicked | Excel Programming | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
User Form Button Code | Excel Programming | |||
Code Needed - new user | Excel Programming | |||
How do I check if a user clicked the Print Cancel button | Excel Programming |