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

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

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


.