AIN3701 ASSIGNMENT 2 2024
DUE: FRIDAY 12 JULY 2024 @23:00
Step 1: OPEN Excel file from the school site → save file as a macro enabled workbook
with your student number , surname and A2 i.e 123456_Du toit _A2.xlsm NOT Excel
workbook
Step 2: Go to DEVELOPER → Visual basic → insert module → Coding sheet
Please not that I have colour coordinated according to how it will look in the coding
sheet after successfully keying in each command.
Now START.
DUE: FRIDAY 12 JULY 2024 @23:00
Step 1: OPEN Excel file from the school site → save file as a macro enabled workbook
with your student number , surname and A2 i.e 123456_Du toit _A2.xlsm NOT Excel
workbook
Step 2: Go to DEVELOPER → Visual basic → insert module → Coding sheet
Please not that I have colour coordinated according to how it will look in the coding
sheet after successfully keying in each command.
Now START.