AIN3701
LEARNING UNIT 4
Assessment 7
ACTIVITY 4.8
The following documents contains:
Solutions(in the form of the code) as well
as a guide on how to use it which is
required to complete Activity 4.8 in
learning unit 4.
This is a guidance on how to use the attached VBA code for copying the template and completing it each on its own
worksheet and named after the invoice number following good VBA coding practice.
Before proceeding, it is important to note that plagiarism is a serious offence, and users must not copy this code
in its entirety. Instead, the code should only be used as a guide,
and users should incorporate their own style of coding in line with their school guide. Furthermore, users should
write their own narrations and not replicate the provided text.
The code comprises of 1 Sub Procedure, namely "Sub Generating_Invoice".
To use the code, users must create 1 button on their “Recorded_Sales” worksheet, and the button should be
assigned a corresponding Sub Procedure.
To ensure that all requirements are met, it is recommended that users employ a rubric to check if all expectations
are satisfied.
Finally, it is important to note that commands that explain what each code does are highlighted in green, and
users should take note of these instructions to better understand the code's functionality.
LEARNING UNIT 4
Assessment 7
ACTIVITY 4.8
The following documents contains:
Solutions(in the form of the code) as well
as a guide on how to use it which is
required to complete Activity 4.8 in
learning unit 4.
This is a guidance on how to use the attached VBA code for copying the template and completing it each on its own
worksheet and named after the invoice number following good VBA coding practice.
Before proceeding, it is important to note that plagiarism is a serious offence, and users must not copy this code
in its entirety. Instead, the code should only be used as a guide,
and users should incorporate their own style of coding in line with their school guide. Furthermore, users should
write their own narrations and not replicate the provided text.
The code comprises of 1 Sub Procedure, namely "Sub Generating_Invoice".
To use the code, users must create 1 button on their “Recorded_Sales” worksheet, and the button should be
assigned a corresponding Sub Procedure.
To ensure that all requirements are met, it is recommended that users employ a rubric to check if all expectations
are satisfied.
Finally, it is important to note that commands that explain what each code does are highlighted in green, and
users should take note of these instructions to better understand the code's functionality.
