I have data in column B2-B77 ...I have this macro but I dont know how to make it work with my code....If any value in this range B2-B77 change it must automatically run a macro I have named "History". Rep given for a fundi for the code to make it work -here is the code. My workbooks name is Monday and the sheets name is Seq
Thank you
Please Login or Register to view this content.
Last edited by ricklou; 12-17-2016 at 05:39 AM.
Use the Worksheet Change event in the worksheet class module this is to apply to
Your example is a little vague - is that the code for History or the code you assume goes somewhere to call History? I'm assuming you want to pass the changed cell to the procedure.Please Login or Register to view this content.
This other thing, not mentioned, is this will only work for manual changes, not changes resulting from formula recalcs.
Last edited by cytop; 12-17-2016 at 05:48 AM.
Hi no this code is not in the macro history.....it must only call a macro "History" in my worksheet Monday sheet Seq if any value in the same worksheet changes value -range B2-B77. Hope this more clear now. Thanks for your responseOriginally Posted by cytop
This dont workUse the Worksheet Change event in the worksheet class module this is to apply to
Please Login or Register to view this content.NB History is already a macro I have) If the values in that range change it must call macro History
Last edited by ricklou; 12-17-2016 at 06:06 AM.
That works, subject to what was mentioned in the last comment of my first post, and it has been tested.
So saying "This dont work" is pointless unless you explain what you did, where you added the code and any other information you think might be relevant.
And what does your macro History look like???
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Put your macro in as a new macro. Wento to the sheet and changed B2 from 0 to 1 it did not run macro History
Mentioned previously.
Use the Worksheet Change event in the worksheet class module this is to apply to
This is getting us nowhere. Post an example file with desensitized data and your macro History in it.
Here is the macro it must call......a simple copy paste operation where it delete 1 row. But thats defeating the point B2-B70 if any value there changes it must call it
Please Login or Register to view this content.
where is this sorry I dont know where it is -I thought its a macro ????
Confidential company info I cannot post 24mb file sorry.....just want a simple macro to be automatically run when the values in range change
The problem is that your basic knowledge of VBA is to small.
The code cytop provided is to be placed in Sheet module of sheet Seq.
Please Login or Register to view this content.
Last edited by bakerman2; 12-17-2016 at 06:52 AM.
sorry yes I am no VBA fundi sorry for that and the fact I cannot upload company confidential info dont help either....Sorry but your last one works like a charm thank you so much. Rep will be given to both of youThe problem is that your basic knowledge of VBA is to small.
The code cytop provided is to be placed in Sheet module of sheet Seq.
Please Login or Register to view this content.
You're welcome and thanks for adding rep points.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks