Storing variables from a Userform in an Add In

Hi

I have a userform in an add in which has a number of checkboxes for users to determine form parameters and rather than requiring them to re check them each time the form is loaded I wanted to store the information so that it could be loaded on startup. Unfortunately I cannot find a way to store data within the add in and it seems the most likely option is to write to a text file and store that in the add in folder.

I would like to enquire if anyone has come across a better alternative than using an external file.

Regards

Jeff

You can store the information in the addin (it is just a workbook with special properties, so it has at least one sheet) as long as you remember to save it (assuming you want it to persist between sessions) or you could put it in the registry using either SaveSetting or more complicated registry functions depending on where you want to put it.