Click here to Skip to main content
15,868,002 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi please help me to make VBA code. If column A cell value changed, In column B cell count that every change.


What I have tried:

Hi please help me to make VBA code. If column A cell value changed, In column B cell count that every change.
Posted
Updated 8-Dec-22 15:29pm

1 solution

You would have to handle the Worksheet.Change event (Excel)[^], check the Range object you get to the cell that changed, make a decision on if your calculations and changes have to be made, then make that change.

That's about the only description you're going to get based on so little information in your question.
 
Share this answer
 
Comments
CHill60 9-Dec-22 8:43am    
"That's about the only description you're going to get based on so little information in your question." - And yet it contains everything the OP needs to know - including Intersect. 5'd
Dalip Sharma 12-Dec-22 12:23pm    
Hi Dave I'm new on vba so can you submit code here.
Dave Kreskowiak 12-Dec-22 13:03pm    
No, I'm not writing your code for you.

You're not writing my code for me, so, there we are.
Dalip Sharma 16-Dec-22 8:52am    
Hahahaha thank u bro.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900