Generic Command Button Response
 

Is there a way to set a command buttons response.
what i am trying to do is to use 1 user form and have generic responses from
the command buttons on that form so that it can be used for multiple things
can it be set
example
if command button is pressed name "what"
its resp to "1" or "what"
like msgbox vbyesno except customized
and is it put into that command buttons code

Generic Command Button Response
 

Each commandbutton has its own click event that fires when it is pressed.

There are methods to link several commandbuttons to a single event. Such a
method is documented at John Walkenbach's site:

http://j-walk.com/ss/excel/tips/tip44.htm
Handle Multiple UserForm Buttons With One Subroutine

--
Regards,
Tom Ogilvy


"David W" wrote in message
...
Is there a way to set a command buttons response.
what i am trying to do is to use 1 user form and have generic responses
from
the command buttons on that form so that it can be used for multiple
things
can it be set
example
if command button is pressed name "what"
its resp to "1" or "what"
like msgbox vbyesno except customized
and is it put into that command buttons code