A Spreadsheet task using a very small interface
Keerside Primary school has a weather recording project that is undertaken by the infant classes. At noon each day pupils record the rainfall for the last 24 hours and the temperature at noon. These two figures are entered into a spreadsheet and used to produce a graph showing both rainfall (as a bar chart) and temperature (as a line graph) for the calendar month. The spreadsheet also calculates the average rainfall and temperature for the month so far.
Because the spreadsheet is to be used by infant children the school want an interface that is simple to use and does not require the pupils to enter data directly into the spreadsheet. Your task is to create a user form in VBA which is automatically displayed when the spreadsheet is opened and which allows the pupils to select the month and date in the month from combo boxes and to enter the rainfall and temperature into text boxes. Once this is done the pupils can select a command button to transfer the data into the correct worksheet (there should be one for each month) and then display the sheet showing the weather recordings for the month, the graph and the averages. From the sheet the pupils should be able to quit the spreadsheet using a command button.
For this task you only need to include sheets and write VBA code for January, February and March. You should hand in a copy of your spreadsheet on disk.
I have already created the graphs and can enter data directly into the spresadsheet to update the graphs but am now trying to transfer the data from a simple user interface to do the same job. I have attached the workbook as is so far
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
Windows 9X and XP