On Aug 15, 10:04*am, Pierre wrote:
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