Auto-Run Macro when Cell Value Changes

Dear all, I understand this subject has been mentioned many times across the forums and I've tried searching for a solution that could work but perhaps I am missing something in the codes that I've put up.

What I am trying to do is to run a particular case of macro when a certain value is entered into a cell.

E.g. When Cell A1 shows 1 , auto run MacroDate_1
When Cell A2 shows 2 , auto run MacroDate_2

and this pretty much goes on until 31. Below are the codes that I've found and modified so far. I've attached it to the 'Sheets' but nothing happens. Apologies as I am not able to send a spreadsheet on this.

Thanks in advance for taking a look at this.

Please Login or Register  to view this content.

Maybe: (per your e.g.)

Please Login or Register  to view this content.

Hi John,

Thanks for the reply ! Also realized why it was working was because the cell i was referring to is a formula and not actual values. Nevertheless thanks for the reply ! I went along this route instead

Please Login or Register  to view this content.

You're welcome. Glad you got a solution.