The list box on sheet “Step 3 - Define Causal Factors” is where users select the Event to work on. The system is designed to handle a maximum of five events. In the upper right had corner of sheet “Step 3 - Define Causal Factors” there is a series of LOAD and SAVE buttons.
The macros assigned to the buttons either load all the data for the selected event or save all the data for the selected event.
The problem is when a user the list box to select a different event. The macro does not save the data to the existing event before changing to the new event. There are 5 load macros and 5 save events.
How can I solve this problem?