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

On Aug 15, 10:04*am, Pierre <henp...@mweb.co.za> 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

On Aug 15, 5:46*am, james.bi...@gmail.com wrote:
> On Aug 15, 10:04*am, Pierre <henp...@mweb.co.za> 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

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

Were you experimenting with class modules?

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



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

--

Dave Peterson

On Aug 16, 12:58*pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> Were you experimenting with class modules?
>
> Like John Walkenbach describes:http://spreadsheetpage.com/index.php...e_userform_but...
>
> 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
>
> --
>
> Dave Peterson

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,