Hi all,
My worksheet_change code is not working at all, and I can't figure out why. I've tested even the most basic worksheet_change code, and it's still not firing:
Am I missing something blatant in the code here, or is there an excel setting that's not configured correctly? All of my other macros are working fine.
Please Login or Register to view this content.
Thanks in advance,
Jeff
I copied your code verbatim and it works fine for me. What are you expecting? It fires whenever you change a cell in the sheet, not when you change from one sheet to another.
Last edited by davegugg; 04-08-2010 at 11:46 AM. Reason: Spelling error
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Yes, that's exactly what I'm expecting, and strangely it's not happening for me. When I change any cell in this one sheet, nothing happens. No message box. Thanks for trying - let me know if you have any more suggestions...
How are you changing the cell? Manually or as the result of a formula? (the former will work, the latter won't).
You can also open the VBEditor (Alt+f11) then the Immediate Window (Ctrl+G) and type in:
and press enter.Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
Are macros enabled?
Is the code in the Sheet module?
Is the code in the correct Sheet module?
Just asking ....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks