I recently added an option to chart some of my data and display the graph on a userform.
Here is the problem I am running into:
I click an option button on Userform1 to show the chart
Userform2 opens, Userform1 closes
I click an option button on Userform2 to select which set of data to use
The chart window appears in the background
Userform3 appears with the picture of the chart on it, but Userform2 is still visible (unwanted)
I click a command button on Userform3 to go back to the Userform1 (report menu)
The chart window, Userform2, Userform3, and any subsequent userforms stay visible on the screen, despite unload commands in the code.
How do I get the chart window to close? This is just a cosmetic problem, but I can't figure out how to get it to work properly.
Here is the problem I am running into:
I click an option button on Userform1 to show the chart
Userform2 opens, Userform1 closes
I click an option button on Userform2 to select which set of data to use
The chart window appears in the background
Userform3 appears with the picture of the chart on it, but Userform2 is still visible (unwanted)
I click a command button on Userform3 to go back to the Userform1 (report menu)
The chart window, Userform2, Userform3, and any subsequent userforms stay visible on the screen, despite unload commands in the code.
How do I get the chart window to close? This is just a cosmetic problem, but I can't figure out how to get it to work properly.