I have created a VBA macro that provides a review of inspection data:

Nominal=10
Accuracy=±2
Inspection Data: 10,10,12,15,10

The macro reviews each data record against the upper and lower limits of the specification.

I have the macro assigned to a hostspot of an image. My users have to click it to run the macro after data is inputted.

QUESTION:
How can this be automated so the macro will run on any update or change of data versus manually clicking a button?