LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 97
Default CommandButton not responding

On Jan 12, 1:28*pm, "Peter T" <peter_t@discussions wrote:
Carim" wrote in message

<snip

What I am after since the very beginning is :
"What is it that I have done wrong ... which prevents only ONE button
out of 20 not to respond ...?"
At least, we both agree it has nothing to do with the code itself ...
since it is common to the 20 Buttons ...
So , in your opinion, What could that be ...?


I don't have any opinion because I don't know what you have, here are some
guesses:

- One of the controls is not a commandbutton
- For some reason the relavant class was not created
- For some reason the relavant class was created a ref to the class was not
stored
- For some reason the relavant class was created and stored but destroyed
- The class was created and stored fine but for some reason a reference in
the class to the button was not set
- Everything is working fine but for some reason you are not seeing the
event being triggered

It would be very easy for you to step through and debug the classes being
created and destroyed. Temporarily insert Initialize and Terminate events in
the class, in the latter include say debug.? btn.name, btn.Caption (change
'btn' to whatever object ref name you are using).

Regards,
Peter T


I will go step by step through my six possible errors ...
Thanks a lot for your help and all your advice.
Cheers


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not responding...... Steve Excel Worksheet Functions 0 November 23rd 09 10:25 PM
why does it say not responding genyjoL New Users to Excel 2 October 22nd 09 05:13 AM
CommandButton not responding Rick Rothstein Excel Programming 0 January 10th 09 05:22 PM
Macro is not responding Len Case Excel Worksheet Functions 5 January 11th 08 06:18 PM
Excel is not responding. Rei New Users to Excel 2 April 23rd 06 05:15 AM


All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"