Detect a change in a Form

[AlexanderBB]

My form sets up various parameters which are stored and used later. The user can change these to their preferences.
When the Forms closed I ask Save Yes/No. But I don;t need to if nothing's changed.
Is there anyway to know that without comparing every item. There's about 30 items that could change.
I'm petty sure there's not... but... ??

 

[Domenic]

When you say that the user can change those parameters to their preferences, I'm assuming via code, correct? If so, you could declared a module-level Boolean variable to track whether a change has been made to the UserForm. So, when a change to a parameter is made, you would assign True to your Boolean variable. And, when the UserForm closes, you would first check the variable to see if a change has been made. If so, then you would ask whether to save.

Hope this helps!

 

[AlexanderBB]

That's what I thought... meaning the boolean would need to be set on every change possible.