Worksheet_Change Issues

[juliabrushett]

Okay, so correct me if I'm wrong, but the purpose of the Worksheet_Change function is to run your code and update each time something is changed in the actual Excel sheet, right?

I am having trouble using the Worksheet_Change method in my VBA program. Photos here of my code and then of my worksheet:

https://drive.google.com/file/d/0B8hxU3V2A7OlbXYxRGo2UlhqZk83dUhPaTlEMTFNVnNLYmVZ/view
https://drive.google.com/file/d/0B8hxU3V2A7OlQTdjTFQ1X3h4YTBiUUVJX2htZmV2RmJaZzlz/view

The idea is to have a heat map made based off of some color-scaled conditional formatting. While the map and conversion from cells->shapes works fantastically with the regular Sub method, I just can't get the Sub Worksheet_Change to workout.

Just an FYI, I am VERYYYY elementary when it comes to VBA. My background is in Java and Python, and so I've been trying to learn VBA for use with Excel but have just started, and with very basic remembrances of the language from High School, am probably struggling over something so trivial

 

[Joe4]

but the purpose of the Worksheet_Change function is to run your code and update each time something is changed in the actual Excel sheet

To clarify, it only runs when a cell on that sheet is manually updated. So it would not capture values that are changed via formula (or Conditional Formatting).

The Worksheet_Calculate event is triggered when any values change (i.e. as the result of formulas), though it cannot pinpoint exactly which cell it was that changed.