Revision Exercises Week 4 Programming

The first thing we'll be doing this week is creating a small Excel application to store information about computer hardware. Create a new spreadsheet and save the file as ComputerHardware.xls.

We'll first need to decide together on what information our application should store. It's really important that the information entered into our application is correct, as our customer is using it to update the prices on her website each month, so we're going to create our own customised forms to make the data-entry as simple as possible!

Our form will need to have input controls (fields/radio buttons/dropdowns etc) and labels corresponding to each field on our spreadsheet, but this time we're going to use a special naming convention to name our controls and labels.

When the user clicks on our OK button, the information from our form should be entered automatically onto the spreadsheet (well, at least the text boxes for a start!).

Finally, our form also needs to have an 'About' button which, when clicked, will display a message box telling the user that we created the program and a contact email/web address, for example:

This application was created by Jo Harvey. http://customapps.blogspot.com

But there's still a small problem with this application... any ideas as to how we might fix it?