VBA for Excel very small but need fast

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


## Deliverables

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.

## Platform

Windows 9X and XP

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, Visual Basic

Veja mais: which graph to use for data, want to create a chart, vba work, the month of january, quit job, quit a job, php code for calendar, month of january, january is the month of, january is month, graphs for data, for the month of january, for graph, excel form to enter data, excel command line, data for graphs, data for graph, data for a graph, create line graph and line chart, create line graph, create a line graph, create a bar chart, command line excel, vba for, line graph excel

Acerca do Empregador:
( 1 comentário ) United Kingdom

ID do Projeto: #2969831

Concedido a:


See private message.

$17 USD em 2 dias
(1275 Comentários)

4 freelancers are bidding on average $20 for this job


See private message.

$25.5 USD in 2 dias
(58 Comentários)

See private message.

$25.5 USD in 2 dias
(22 Comentários)

See private message.

$12.75 USD in 2 dias
(28 Comentários)