How to make vba code run automatically anytime there is an update on worksheet.

Hello!

New to VBA so I do not know the correct verbage to use, but I will try to be as clear as possible.

I want to be able to have my code run anytime there is an update to the worksheet I am using without using a Command Button.

Please know I am not asking this question idly. I have been doing research for DAYS. My brain is fried from all the Google searches. I actually hope this is a super simple thing and that the reason I can't find anything is because it is so simple no one bothers posting how to do it.

Thank you in advance for your time!

Hi & welcome to the board.
Have a look at Worksheet_Change events
http://www.excel-easy.com/vba/events.html

You will do this using the worksheet change event. The easiest way to do this is to right click the tab and choose the "View Code" option. This will open the VBA editor for that specific worksheet. This is what the code will look like:

Please Login or Register  to view this content.