I have this VBA to saves changes (date Values) on cells as comments, but when I run a date picker (an add in ) I get an error which says the following:
Run-time error 1004
Method Undo of objet Application failed
Please what can I do??
This is the VBA
Please Login or Register to view this content.
That's working for me in my test. Are you doing something specific that is causing it to fail?
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Well, you can get around using the Application.undo (which I finally was able to make break the function) by using a History Column.
Here's what I did:
-I named the column I want to track trackedColumn and the column that holds the last value historyColumn. I made these workbook-scoped names available to VBA using bracketed expressions: [trackedColumn] and [historyColumn].
-ALSO I noticed you were having trouble with user updates involving more than one cell at a time (hence the check target.count...) - You can get around that problem (and still capture changes of more than one cell at a time due to larger copy/paste operations) by using a FOR EACH loop.
FIRST CHECK BECOMES:LOOP IS (which is only reached IF the first check is passed - meaning we have at least one change in the tracked column to make note of... could be many cells)Please Login or Register to view this content.
Please Login or Register to view this content.
FULL Macro for worksheet_change event handling:
Please Login or Register to view this content.
-That history column can be buried away on some hidden control sheet also. Anyway, that's my thoughts on it - would be preferable IMO to using the undo option.
Also, if you wanted to get the comment out of the way - you could place it on the history column. Instead of Target.NoteText you would just use [historyColumn].cells(c.row,1).NoteText.
Last edited by GeneralDisarray; 07-17-2015 at 09:51 AM. Reason: EDIT - Attached Example
Hi , Yes Yes it works when I put the dates on columns T manually, BUT if I use the Date picker Add inn, it stops working and give the Run Time error 1004 and the VBA stops working until I shut down excel and I start from new.
What could ti be
Are you talking about my code or your original code?
Were you able to try what i posted?
Yes my original code , the problem is that when ever I run the Date Picker Add inn , the VBA stop working .. i am afraid there muss be a mishmash between VBAs and the Date picker Add In
Ok, seeing as that is the case, you might want to try something else. Have you tried what I posted??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks