Aftersave event - boolean issue

[D_N_L]

Hi all,

Can anyone explain why my code isn't working below? Upon the first instance of the user clicking 'Save' I want a MsgBox to appear. All subsequent saves this should then not appear. I thought the below code would do it:

Please Login or Register  to view this content.

[rkey]

Hi DNL

The event will trigger, every time a user clicks on Save.
To pass the value from SavedAlready to the next time the sub runs you can declare it as Public variable (outside your sub).
And make sure A1 is > 0.

Please Login or Register  to view this content.

[D_N_L]

I'd missed the Public off my declaration! Thank you!

Sometimes it's the small things huh!