Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delayed response to any command | New Users to Excel | |||
command button add another command | Excel Discussion (Misc queries) | |||
How do I transform a word response to a numeric response? | Excel Discussion (Misc queries) | |||
How do I set up a daily call out response response register? | Excel Worksheet Functions | |||
Command Button | Excel Worksheet Functions |