| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine which button
OK I'm dumb. I asked this question a few months ago and
got the answer. Only trouble is I forgot to save it and my memory is horrible. I have multiple form buttons all assigned to the same macro. How do you determine within the macro which button called it? Thanks for any help, Senile |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determine which button
Hi Senile
Application.Caller you can use -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Senile" wrote in message ... OK I'm dumb. I asked this question a few months ago and got the answer. Only trouble is I forgot to save it and my memory is horrible. I have multiple form buttons all assigned to the same macro. How do you determine within the macro which button called it? Thanks for any help, Senile |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determine which button
That was it!! Thanks very much Ron!
-----Original Message----- Hi Senile Application.Caller you can use -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Senile" wrote in message ... OK I'm dumb. I asked this question a few months ago and got the answer. Only trouble is I forgot to save it and my memory is horrible. I have multiple form buttons all assigned to the same macro. How do you determine within the macro which button called it? Thanks for any help, Senile . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Undo button and redo button quit | Excel Discussion (Misc queries) | |||
| Inserting a Graphic on a Button when the Button is Assigned to a M | Excel Discussion (Misc queries) | |||
| How to determine button reference | Setting up and Configuration of Excel | |||
| How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
| How to determine which button was clicked on the modified right-click menu | Excel Programming | |||
Linear Mode
