Saving combo box list when closed?

[Josh Ashcraft]

I need my userform comboboxes to keep their list values
when the program is closed, and the selected value in the
combobox needs to saved too. So when i open the workbook,
the comboboxes keep their lists from before, and whichever
value was selected from the combobox stays in there, how
would i do that?
thanks in advance
Josh Ashcraft

 

[Tom Ogilvy]

Set the row source manually in the VBE. If you are not getting your data
from the worksheet, then you would need to run code to repopulate the lists.
Likewise, you would need to store the selected value in a cell or somewhere
else, and then reset it with code, possibly in the initialize event.