Hi all.
VBA part-timer here.
i've been using the following code to track updates on a row by row basis in a table
this works perfectly - however i seems to be causing excel to crash regularly, and also seems to be running slow.
Please Login or Register to view this content.
i'm thinking it has something to do with defining the values. i'm really not sure where to start with this one.
any assistance is appreciated.
Last edited by JBeaucaire; 10-12-2016 at 12:50 AM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
Nuthin wrong with that, if it's crashing Excel I'd reinstall Office....and maybe Windows too.
I'd tend to disagree - both that there's nothing wrong with it and that it works perfectly.
The basic problem with the code is that, as posted, it will cause a cascading event.
You change a cell, the code changes the cell in Col P of that row. That raises another Change event which changes Col P, which raise another Change event and so on. Excel will crash... in about 100 milliseconds.
You should disable Event handling if changing a cell in the Change event...
Please Login or Register to view this content.
Doh. Yep, the event will cycle unless events are turned off.
What he said.
Yep that did the trick.Originally Posted by cytop
I'd tend to disagree - both that there's nothing wrong with it and that it works perfectly.
The basic problem with the code is that, as posted, it will cause a cascading event.
You change a cell, the code changes the cell in Col P of that row. That raises another Change event which changes Col P, which raise another Change event and so on. Excel will crash... in about 100 milliseconds.
You should disable Event handling if changing a cell in the Change event...
Please Login or Register to view this content.
Thankyou so much, it really was causing my brain to hurt.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks