Hi,

does anyone know the CODE to "automatically" save the XLA file that holds the code of a userform which the user is just busy with? I'd like to have the settings saved that the user has made in e.g. comboboxes? In other words, I am trying to avoid that the userform falls back to the original default settings, when called newly. In this example, the user can change the date format of a calendar (and other things) and it would be great if those settings are 'memorized', even after Excel has been closed and restarted.
A solution would be a "Save Settings" button, provided I knew what code to put behind it
The code would 'just' need to save the Add In, in other words, the XLA file.

THANK YOU!!!

Ben