One of the ways to store a variable when closing and re-opening workbook is with CustomDocumentProperties.
The variable changes depending on selection (one of 3 values).
Selection is from userform option buttons.
Below code works only for 1 selection and then have to exit form.
How can it work...