Call Macro when cell value changes to specific value

[Lyncz92]

Hey Reader,

I got stuck in my project

I have create a sheet where i have 15 row that have to be filled in with grade's. In the last collum there is formula that send's back the higest grade of that specfic row. What i want is that when the value of that formula = 3 run macro.
atm i use this:

Please Login or Register  to view this content.

After filling in the form it will bring back the user to the sheet where he was working in. The user will now go on filling next row but than i face a problem. cus he will again have to fill in the form because the vba code registers again a "3" in range "AG2".

what i basically want is that vba only call's the macro when a specific cell change to a value of "3".

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules, they are not many

[Pepe Le Mokko]

Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile says Win10...

[Lyncz92]

Alright got it thanks for changing it. i will keep it in mind for next threads

[KOKOSEK]

Please Login or Register  to view this content.

You've written value of "3", so I assume 3 as number.

[Lyncz92]

Hey KOKOSEK,

thanks for your quick response. A moderator did change the thread with Code tag and informed me about the rules. i will keep this in mind for next thread.

The "3" stance indeed for a number

[Lyncz92]

Hey KOKOSEK,

I have tested your code but that didn't work for me. and i really can't find the reason why it won't work. i have uploaded the file so you can see how it looks maybe you can find out whats the problem.

[KOKOSEK]

Is not about AG2 is about range AG2:AG16 as I see (if I am not mistaken).
Try then:

Please Login or Register  to view this content.

[Lyncz92]

I have test this and it does the same as worksheet change action.

it checks the value's in range AG2:AG16 after every change in whatever cell. so for example:

if i change the value in AG2 to 3 and enter the macro will run which is okay.
after filling in form i want to go on and i fill in AG3 to a value of 2 and enter the macro will start running again and sees the 3 in AG2. this cause again he will open form which i dont want because it was already filled in for range AG2.

maybe this is impossible?

[KOKOSEK]

Lets check then if we are checking latest row:

Please Login or Register  to view this content.

[Lyncz92]

Thanks mate this did it .

[Lyncz92]

Got 1 more issue which you maybe know how to fix.

i need Error Handling on this sheet for when you fill in a incorrect size. because when i now fill in a incorrect size now on D2 the value in AG2 will be ### which will result in a error in the VBA code.

i used a IsError formula but that won't work??

Please Login or Register  to view this content.

[KOKOSEK]

Try:

Please Login or Register  to view this content.