Forum Discussion
Solved
Saving Changes made to VBA Form during Macro Execution
I have a VBA Form that has several defaults (e.g. two Checkboxes are true and a Text Box has a value the first time it is shown). However, I want to save all the values of the form before it is unloaded so the next time it is shown it will have the new values.
Can the form values be updated and saved during macro execution?
OR
Do I have to store the values in the spreadsheet and set them before the form.show command?
The last: Store the values in the spreadsheet and set them in the userform's initialize event.
1 Reply
The last: Store the values in the spreadsheet and set them in the userform's initialize event.