Preserve values from a userform when red X button is clicked

Hello Magmarinita,

Just place a messagebox with a question and listen to the response and take action from there...

Please Login or Register  to view this content.

Now it depends what you mean with save the data...
If you are going to "save it" in the sense that you want to use it directly in your code then you could either just assign the data to a global variable, or you can access the form data later by referring to theuserform...

Please Login or Register  to view this content.

if you are going to save it temporarily somewhere to pick it up later, you could just save it in a cell somewhere

Please Login or Register  to view this content.

if you want to save the data, like statistics, you could save it in a listobject, a table...

Please Login or Register  to view this content.

Hopefully this guide you in the right direction.