Command button executes without code???

[Pierre]

This may sound weird and will probably create a few smiles.
I have a userform with a command button that prompts the user for
input via an input box during runtime.
This works fine, but when I look for the code assigned to the command
button in design mode there is no code except the normal Sub
commandbutton3 click and End Sub syntax. How is this possible? I've
looked everywhere in the Sheet objects and modules for the code. I
worked on the code a couple of days ago and cannot remember where I
might have coded the command button.
I know Excel is good - but not that good
Any Ideas? I am at wits end.

Thanks

 

[james.billy]

This may sound weird and will probably create a few smiles.
I have a userform with a command button that prompts the user for
input via an input box during runtime.
This works fine, but when I look for the code assigned to the command
button in design mode there is no code except the normal Sub
commandbutton3 click and End Sub syntax. How is this possible? I've
looked everywhere in the Sheet objects and modules for the code. I
worked on the code a couple of days ago and cannot remember where I
might have coded the command button.
I know Excel is good - but not that good
Any Ideas? I am at wits end.

Thanks

So I assume the commandbutton3 click sub is behind the userform, when
you are in between the sub and end sub, goto to just below the menu
you should see two drop downs, the first will have commandbutton3 in
it and the second will say click, if you select the drop down that
says click are any others highlighted (i.e. in bold), what I am
getting at is have you assigned more than one event to the
commandbutton (i.e. an enter event or something like that?!)
alternatively scroll down the userform code looking for another
commandbutton_?????? event.

James

 

[Pierre]

So I assume the commandbutton3 click sub is behind the userform, when
you are in between the sub and end sub, goto to just below the menu
you should see two drop downs, the first will have commandbutton3 in
it and the second will say click, if you select the drop down that
says click are any others highlighted (i.e. in bold), what I am
getting at is have you assigned more than one event to the
commandbutton (i.e. an enter event or something like that?!)
alternatively scroll down the userform code looking for another
commandbutton_?????? event.

James

James, sorry for the delay. my Google account expired. I have tried
your suggestions - without success. I wiil keep on looking, thanks

 

[Dave Peterson]

Were you experimenting with class modules?

Like John Walkenbach describes:
http://spreadsheetpage.com/index.php/tip/handle_multiple_userform_buttons_with_one_subroutine/

 

[Pierre]

Were you experimenting with class modules?

Like John Walkenbach describes:http://spreadsheetpage.com/index.php/tip/handle_multiple_userform_but...

Dave, Thanks for the reply. I'm too much of a "newby" to experiment
with VBA. I will certainly study JWalk's weg page as you suggested,