VBA code to throw a pompt when user modifies data

Hello,

I am looking for VBA code that will prompt the user to click on "Calculate button" only if modifies data and not otherwise.

Its a protected workbook with VBA. I have a drop down in B18 and D20. I want to throw a prompt only if user changes the drop down value only in B18 and D20.

If he modifies data on any other cell or if he doesnt change the any value "No prompt required".

Please help me with VBA code on this...

This should do it…. It need to be placed in the vba for the sheet you want it to run on

Please Login or Register  to view this content.

Hi,

I am afraid that dint help.

1. Its prompting for password even when I change the values in other drop down.
2. When I click on "Ok" on the prompt its not calculating. So, ideally its not clicking on "Calculate button"

Fyi, its a form button and name on the button is "Calculate" . Hope it helps

will prompt the user to click on "Calculate button" only

and

So, ideally its not clicking on "Calculate button"

???? So who should click the calculating button, the user or the macro?

Alf

Here you are!

I want macro to click on calculate button, if possible.

Basically, when user gets a prompt he should get 2 options "ok" and "cancel". When he selects "Ok" , it should automatically click on calculate button.

Also, most important thing is. It should prompt user when he changes value in drop down any other cell apart from B18 and D20.

Note: On my tab, I have 5 drop down list. So I want to throw a prompt only when he changes value on B18 and D20.

@gaixixon. Exactly thats true!! One thing you missed is...if user makes changes on any other cell apart from B18 and D20, it should not trigger the prompt.

Got what ya mean.. Sorry I uploaded wrong file.. Here you are.
You need to work on the code yourself to fit your need.