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 wrote:
On Jan 10, 6:22 pm, "Rick Rothstein"
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" wrote in message
....
On Jan 10, 5:55 pm, "Rick Rothstein"
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" wrote in message
....
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 ... ???