View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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