Applications Programming --- Lab 11

Objective:

• Have fun playing with multiple userforms in one VBA program

Problem description:

Create an application that displays the astronomical data about the planets of the solar system (including Pluto, which is no longer considered a planet). You can find the data in the Excel file lab11-input.xlsx.

The application should have a main form that has at least the following controls:

• A list box that shows a list of the planet names and allows the user to select the planet he/she wishes to know more about.
• A command button captioned "View details". When clicked, a new form will be shown with the selected planet's information displayed.
• Another command button captioned "Exit". When clicked, the whole application should be terminated.

When the userform that displays the selected planets detailed information is shown, the main form should be hidden. And the information userform should have one command button captioned "Back". When clicked, the information userform should be unloaded and the main userform should be shown again.

For controls in both forms, set the properties such as accelerator, tabstop, cancel and default properly so that the interface is more user friendly.