Saving combo box list when closed?

  • Thread starter Thread starter Josh Ashcraft
  • Start date Start date
J

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
 
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.
 
Back
Top