Excel programming

  • Develop a user forms that will solve the following problem.
    1. Initiate weights for TM1, TM2, TM3 and TM4 as 15%, 35%, 25% and 25%. Calculate the final
    mark based on the four test marks provided by the student.
    The application must have:
    A. A button in excel (create a blank workbook) to load the form. When someone clicks on this
    button the form must be displayed with the following information -
    1. Labels for all test marks
    2. Text boxes for all test marks for the user to enter marks
    3. Four buttons – to reset the form, close the form, calculate final marks and to upload
    the mark in excel
    4. A label to display the results on the form.
    Calculation – you must declare all variables needed in the application
    Variables - TM1, TM2, TM3, TM4, FinalMark as double
    Assign – TM1 = 0.15, TM2 = 0.35, TM3 = 0.25, TM4 = 0.25
    Buttons – btnReset, btnCalcFMark, btnUpload, btnClose
    Labels – lblTM1, lblTM2, lblTM3, lblTM4, lblResults
    Textboxes – txtTM1, txtTM2, txtTM3, txtTM4
    Upload button – Will take the final mark displayed in the results label and upload the results to
    excel.

  • This is homework. Read the Forum Rules about homework.


    If you make some effort yourself then we will probably help. We will not do your homework for you.