An Excel Picture Viewer

In this section, you'll learn how to create a more elaborate form. This form will have text and combo boxes, options buttons, tabs, and a picture box. What you'll create is a picture viewer that looks like this:

The first tab pulls image information from a spreadsheet. The image associated with the information is also displayed.

Notice the button at top of the View Photos tab. It says Load Image Information . When this button is clicked the form changes to this:

Loading the image information activates the Previous Photo and Next Photo buttons. Clicking these buttons allows us to display other images.

All this image information is coming from a spreadsheet. This spreadsheet:

The second tab on our picture viewer is for adding new image information to the spreadsheet. It looks like this:

Clicking the Add New Picture button displays the Open File dialogue box where we can select an image. This image will appear in the picture box on the form. The Save New Details button becomes active once an image is selected. The text boxes can then filled out before these new details are added to the spreadsheet.

Let's make a start.