saving data in a VBA form

[AJSatori]

I have a form that I created in VBA for Excel. Everything works, but after I populate everthing on the form (checkboxes, dropdown lists) and then close it down, it does not hold the data for when I bring it back up again. How can I keep the data that I place n my VBA form?

 

[Juan Pablo González]

The easy thing to do is don't unload it, just hide it. In other words, change

Unload Me

with

Me.Hide