Hi,

Based on John's tip 44 to handle several commandbuttons with the same
routine :
http://www.j-walk.com/ss/excel/tips/tip44.htm
I am facing a strange problem since a single commandbutton refuses to
respond ...

Any hints ...?
Thanks in advance for your comments
Cheers

What do you mean by "a single commandbutton refuses to respond"... that you
have several buttons, but one doesn't respond... or that you only have that
one button and it doesn't repond?

Also, did you modify the code at all? If so, show us the code you are using
(and tell us which button is not responding).

--
Rick (MVP - Excel)


"Carim" <(E-Mail Removed)> wrote in message
news:a7024b76-6c66-4ab0-8f38-(E-Mail Removed)...
> Hi,
>
> Based on John's tip 44 to handle several commandbuttons with the same
> routine :
> http://www.j-walk.com/ss/excel/tips/tip44.htm
> I am facing a strange problem since a single commandbutton refuses to
> respond ...
>
> Any hints ...?
> Thanks in advance for your comments
> Cheers

On Jan 10, 5:55*pm, "Rick Rothstein"
<rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> What do you mean by "a single commandbutton refuses to respond"... that you
> have several buttons, but one doesn't respond... or that you only have that
> one button and it doesn't repond?
>
> Also, did you modify the code at all? If so, show us the code you are using
> (and tell us which button is not responding).
>
> --
> Rick (MVP - Excel)
>
> "Carim" <carim...@yahoo.com> wrote in message
>
> news:a7024b76-6c66-4ab0-8f38-(E-Mail Removed)...
>
>
>
> > Hi,
>
> > Based on John's tip 44 to handle several commandbuttons with the same
> > routine :
> >http://www.j-walk.com/ss/excel/tips/tip44.htm
> > I am facing a strange problem since a single commandbutton refuses to
> > respond ...
>
> > Any hints ...?
> > Thanks in advance for your comments
> > Cheers- Hide quoted text -
>
> - Show quoted text -

Hi Rick,

You are right ... 20 Buttons and one of them refuses to respond ...???
Since the code is absolutely identical for all 20 CommandButtons,
would assume
the problem is elsewhere ... all properties are obviously identical
too ...
What would be your intuition ... ?
Cheers

Which of the 20 CommandButtons is the one that isn't responding.

And you didn't answer.... did you change the posted code in any way? If you
did, post your code.

--
Rick (MVP - Excel)


"Carim" <(E-Mail Removed)> wrote in message
news:fa3bba23-3cb1-43e2-b858-(E-Mail Removed)...
On Jan 10, 5:55 pm, "Rick Rothstein"
<rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> What do you mean by "a single commandbutton refuses to respond"... that
> you
> have several buttons, but one doesn't respond... or that you only have
> that
> one button and it doesn't repond?
>
> Also, did you modify the code at all? If so, show us the code you are
> using
> (and tell us which button is not responding).
>
> --
> Rick (MVP - Excel)
>
> "Carim" <carim...@yahoo.com> wrote in message
>
> news:a7024b76-6c66-4ab0-8f38-(E-Mail Removed)...
>
>
>
> > Hi,
>
> > Based on John's tip 44 to handle several commandbuttons with the same
> > routine :
> >http://www.j-walk.com/ss/excel/tips/tip44.htm
> > I am facing a strange problem since a single commandbutton refuses to
> > respond ...
>
> > Any hints ...?
> > Thanks in advance for your comments
> > Cheers- Hide quoted text -
>
> - Show quoted text -

Hi Rick,

You are right ... 20 Buttons and one of them refuses to respond ...???
Since the code is absolutely identical for all 20 CommandButtons,
would assume
the problem is elsewhere ... all properties are obviously identical
too ...
What would be your intuition ... ?
Cheers

On Jan 10, 6:22*pm, "Rick Rothstein"
<rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> Which of the 20 CommandButtons is the one that isn't responding.
>
> And you didn't answer.... did you change the posted code in any way? If *you
> did, post your code.
>
> --
> Rick (MVP - Excel)
>
> "Carim" <carim...@yahoo.com> wrote in message
>
> news:fa3bba23-3cb1-43e2-b858-(E-Mail Removed)...
> On Jan 10, 5:55 pm, "Rick Rothstein"
>
>
>
>
>
> <rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> > What do you mean by "a single commandbutton refuses to respond"... that
> > you
> > have several buttons, but one doesn't respond... or that you only have
> > that
> > one button and it doesn't repond?
>
> > Also, did you modify the code at all? If so, show us the code you are
> > using
> > (and tell us which button is not responding).
>
> > --
> > Rick (MVP - Excel)
>
> > "Carim" <carim...@yahoo.com> wrote in message
>
> >news:a7024b76-6c66-4ab0-8f38-(E-Mail Removed)....
>
> > > Hi,
>
> > > Based on John's tip 44 to handle several commandbuttons with the same
> > > routine :
> > >http://www.j-walk.com/ss/excel/tips/tip44.htm
> > > I am facing a strange problem since a single commandbutton refuses to
> > > respond ...
>
> > > Any hints ...?
> > > Thanks in advance for your comments
> > > Cheers- Hide quoted text -
>
> > - Show quoted text -
>
> Hi Rick,
>
> You are right ... 20 Buttons and one of them refuses to respond ...???
> Since the code is absolutely identical for all 20 CommandButtons,
> would assume
> the problem is elsewhere ... all properties are obviously identical
> too ...
> What would be your intuition ... ?
> Cheers- Hide quoted text -
>
> - Show quoted text -

Well, it is CommandButton10 out of the sequence which goes from
CommandButton6
to CommandButton25 ...
And I have not touched the code whatsoever ....

On Jan 10, 6:30*pm, Carim <carim...@yahoo.com> wrote:
> On Jan 10, 6:22*pm, "Rick Rothstein"
>
>
>
>
>
> <rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> > Which of the 20 CommandButtons is the one that isn't responding.
>
> > And you didn't answer.... did you change the posted code in any way? If*you
> > did, post your code.
>
> > --
> > Rick (MVP - Excel)
>
> > "Carim" <carim...@yahoo.com> wrote in message
>
> >news:fa3bba23-3cb1-43e2-b858-(E-Mail Removed)....
> > On Jan 10, 5:55 pm, "Rick Rothstein"
>
> > <rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> > > What do you mean by "a single commandbutton refuses to respond"... that
> > > you
> > > have several buttons, but one doesn't respond... or that you only have
> > > that
> > > one button and it doesn't repond?
>
> > > Also, did you modify the code at all? If so, show us the code you are
> > > using
> > > (and tell us which button is not responding).
>
> > > --
> > > Rick (MVP - Excel)
>
> > > "Carim" <carim...@yahoo.com> wrote in message
>
> > >news:a7024b76-6c66-4ab0-8f38-(E-Mail Removed)....
>
> > > > Hi,
>
> > > > Based on John's tip 44 to handle several commandbuttons with the same
> > > > routine :
> > > >http://www.j-walk.com/ss/excel/tips/tip44.htm
> > > > I am facing a strange problem since a single commandbutton refuses to
> > > > respond ...
>
> > > > Any hints ...?
> > > > Thanks in advance for your comments
> > > > Cheers- Hide quoted text -
>
> > > - Show quoted text -
>
> > Hi Rick,
>
> > You are right ... 20 Buttons and one of them refuses to respond ...???
> > Since the code is absolutely identical for all 20 CommandButtons,
> > would assume
> > the problem is elsewhere ... all properties are obviously identical
> > too ...
> > What would be your intuition ... ?
> > Cheers- Hide quoted text -
>
> > - Show quoted text -
>
> Well, it is CommandButton10 out of the sequence which goes from
> CommandButton6
> to CommandButton25 ...
> And I have not touched the code whatsoever ....- Hide quoted text -
>
> - Show quoted text -

I am totally lost ...
Should I remove this UserForm and build a brand new one from
scratch ... ???

Guess I am a little dense but I don't understand why the 20 buttons running
the same code from a click event. Or did you modify the event code to do
different things? Anyhow, there should be no need to redo the entire form.
Simply fix the one button by giving it its own click event code. I wonder if
you have checked to see if it has the code for that particular button. In
JWalks code he excluded the OK button. Did you exclude a button and forget
to later assign the code to it? You need to shake off the frustration and
think rationally of what your options are.

"Carim" wrote:

> On Jan 10, 6:30 pm, Carim <carim...@yahoo.com> wrote:
> > On Jan 10, 6:22 pm, "Rick Rothstein"
> >
> >
> >
> >
> >
> > <rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> > > Which of the 20 CommandButtons is the one that isn't responding.
> >
> > > And you didn't answer.... did you change the posted code in any way? If you
> > > did, post your code.
> >
> > > --
> > > Rick (MVP - Excel)
> >
> > > "Carim" <carim...@yahoo.com> wrote in message
> >
> > >news:fa3bba23-3cb1-43e2-b858-(E-Mail Removed)....
> > > On Jan 10, 5:55 pm, "Rick Rothstein"
> >
> > > <rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> > > > What do you mean by "a single commandbutton refuses to respond"... that
> > > > you
> > > > have several buttons, but one doesn't respond... or that you only have
> > > > that
> > > > one button and it doesn't repond?
> >
> > > > Also, did you modify the code at all? If so, show us the code you are
> > > > using
> > > > (and tell us which button is not responding).
> >
> > > > --
> > > > Rick (MVP - Excel)
> >
> > > > "Carim" <carim...@yahoo.com> wrote in message
> >
> > > >news:a7024b76-6c66-4ab0-8f38-(E-Mail Removed)....
> >
> > > > > Hi,
> >
> > > > > Based on John's tip 44 to handle several commandbuttons with the same
> > > > > routine :
> > > > >http://www.j-walk.com/ss/excel/tips/tip44.htm
> > > > > I am facing a strange problem since a single commandbutton refuses to
> > > > > respond ...
> >
> > > > > Any hints ...?
> > > > > Thanks in advance for your comments
> > > > > Cheers- Hide quoted text -
> >
> > > > - Show quoted text -
> >
> > > Hi Rick,
> >
> > > You are right ... 20 Buttons and one of them refuses to respond ...???
> > > Since the code is absolutely identical for all 20 CommandButtons,
> > > would assume
> > > the problem is elsewhere ... all properties are obviously identical
> > > too ...
> > > What would be your intuition ... ?
> > > Cheers- Hide quoted text -
> >
> > > - Show quoted text -
> >
> > Well, it is CommandButton10 out of the sequence which goes from
> > CommandButton6
> > to CommandButton25 ...
> > And I have not touched the code whatsoever ....- Hide quoted text -
> >
> > - Show quoted text -
>
> I am totally lost ...
> Should I remove this UserForm and build a brand new one from
> scratch ... ???
>

On Jan 10, 8:32*pm, JLGWhiz <JLGW...@discussions.microsoft.com> wrote:
> Guess I am a little dense but I don't understand why the 20 buttons running
> the same code from a click event. *Or did you modify the event code to do
> different things? *Anyhow, there should be no need to redo the entire form. *
> Simply fix the one button by giving it its own click event code. *I wonder if
> you have checked to see if it has the code for that particular button. *In
> JWalks code he excluded the OK button. *Did you exclude a button and forget
> to later assign the code to it? *You need to shake off the frustration and
> think rationally of what your options are.
>
>
>
> "Carim" wrote:
> > On Jan 10, 6:30 pm, Carim <carim...@yahoo.com> wrote:
> > > On Jan 10, 6:22 pm, "Rick Rothstein"
>
> > > <rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> > > > Which of the 20 CommandButtons is the one that isn't responding.
>
> > > > And you didn't answer.... did you change the posted code in any way? If *you
> > > > did, post your code.
>
> > > > --
> > > > Rick (MVP - Excel)
>
> > > > "Carim" <carim...@yahoo.com> wrote in message
>
> > > >news:fa3bba23-3cb1-43e2-b858-(E-Mail Removed)....
> > > > On Jan 10, 5:55 pm, "Rick Rothstein"
>
> > > > <rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> > > > > What do you mean by "a single commandbutton refuses to respond".... that
> > > > > you
> > > > > have several buttons, but one doesn't respond... or that you onlyhave
> > > > > that
> > > > > one button and it doesn't repond?
>
> > > > > Also, did you modify the code at all? If so, show us the code youare
> > > > > using
> > > > > (and tell us which button is not responding).
>
> > > > > --
> > > > > Rick (MVP - Excel)
>
> > > > > "Carim" <carim...@yahoo.com> wrote in message
>
> > > > >news:a7024b76-6c66-4ab0-8f38-(E-Mail Removed)..com....
>
> > > > > > Hi,
>
> > > > > > Based on John's tip 44 to handle several commandbuttons with the same
> > > > > > routine :
> > > > > >http://www.j-walk.com/ss/excel/tips/tip44.htm
> > > > > > I am facing a strange problem since a single commandbutton refuses to
> > > > > > respond ...
>
> > > > > > Any hints ...?
> > > > > > Thanks in advance for your comments
> > > > > > Cheers- Hide quoted text -
>
> > > > > - Show quoted text -
>
> > > > Hi Rick,
>
> > > > You are right ... 20 Buttons and one of them refuses to respond ...???
> > > > Since the code is absolutely identical for all 20 CommandButtons,
> > > > would assume
> > > > the problem is elsewhere ... all properties are obviously identical
> > > > too ...
> > > > What would be your intuition ... ?
> > > > Cheers- Hide quoted text -
>
> > > > - Show quoted text -
>
> > > Well, it is CommandButton10 out of the sequence which goes from
> > > CommandButton6
> > > to CommandButton25 ...
> > > And I have not touched the code whatsoever ....- Hide quoted text -
>
> > > - Show quoted text -
>
> > I am totally lost ...
> > Should I remove this UserForm and build a brand new one from
> > scratch ... ???- Hide quoted text -
>
> - Show quoted text -

Hi JLGWhiz,

Thanks for helping me calming down ...and for the invitation to think
rationally.
After a night of not-so-good sleep, and for the sake of future
readers, I found
a solution : include two additional Locked CommandButtons ( lower and
upper bounds )
when building the group ... for the Class module to recognize all the
20 Buttons in-between !!!
Do not ask me why it is working ..., I suspect the couple Excel 2000
SR1 with XP has not yet
solved all of their ActiveX controls handlings ...
Cheers

Hello again Carim,
<snip>
> I found a solution : include two additional Locked CommandButtons
> ( lower and upper bounds ) when building the group ...
> for the Class module to recognize all the 20 Buttons in-between !!!
> Do not ask me why it is working ..., I suspect the couple Excel 2000
> SR1 with XP has not yet solved all of their ActiveX controls handlings ...

The reason your code was not working correctly before is because you had
done something wrong. It is not possible to suggest what you did wrong
because you have not given the details Rick asked you for, two times.

Although you may have fixed it, for now, I am sure the reason is not due to
what you say you suspect.

Regards,
Peter T

On Jan 11, 3:06*pm, "Peter T" <peter_t@discussions> wrote:
> Hello again Carim,
> <snip>
>
> > I found a solution : include two additional Locked CommandButtons
> > ( lower and upper bounds ) when building the group ...
> > for the Class module to recognize all the 20 Buttons in-between !!!
> > Do not ask me why it is working ..., I suspect the couple Excel 2000
> > SR1 with XP has not yet solved all of their ActiveX controls handlings ....
>
> The reason your code was not working correctly before is because you had
> done something wrong. It is not possible to suggest what you did wrong
> because you have not given the details Rick asked you for, two times.
>
> Although you may have fixed it, for now, I am sure the reason is not due to
> what you say you suspect.
>
> Regards,
> Peter T

Hi Peter,

Sorry but I I gave the details Rick asked for ...
1. One Button out of a sequence of 20 Buttons is not responding ...
2. The Code has not been changed ... and working with a Class, all 20
Buttons call
the very same code in the unique class ...
Very honestly, I wish I could understand what I have done wrong ...
cause it is important to keep on progressing ...
I trust you when you say " I am sure the reason is not due to
what you say you suspect ... "
What would be your best guess ... ?
Regards