Thread: Form to output input data into spreadsheet

Hi all,

I am doing a test for year 12 secondary school and i need some help... This to me seems very complicated, as it is regarding VBA.

I have created two forms, (1, NewSale - new car sold) has fields were you can enter the customer name, employee (that sold car) name, car model and date. This i created in VBA (alt+f11). It also has a cancel and save button. Now, when i enter all the required data for the new sale, and press save, i need that data to be entered automatically into a spreadsheet that is in that workbook with the relevant data from the form.

(2, New Employee/Sales Person), this form is also similar to the above, but, when the name is entered for the new Sales person, that name needs to automatically be added to a drop down list which is in the NewSale form. In the NewSale form, under 'Employee Name', when clicked on, it displays a drop down list with all the current staff, so the new staff member needs to entered into that.


Please help if you can,...ask any questions if you are not clear on my explanation,...i have attached the workbook that i am working on..

Thanks!