Create a VBA application in Excel to help automate the business or organisational process you have
decided to address, which must:
1. Have a graphical user interface within Excel such that a person who is familiar with Excel, but
has no knowledge of VBA, can successfully operate your VBA application.
2. Demonstrate the key programming skills expected on successful completion of the module
including use of:
Variables, Constants and Data Types;
Routines, Procedures and Functions;
Conditional Structures and Loops; and
Arrays.
3. Demonstrate a clear understanding of the importance of correctness, usability and readability
in programming.
Report (40%)
Produce a report about your VBA application, which must include:
1. Introduction of your VBA Application:
• The background and rationale to the business issue or problem, which you have decided to
address using a VBA application.
• You may refer to relevant literature, but keep coverage of the literature brief.
• Clearly state the overall objectives of the VBA algorithm.
3. Discussion of the potential impact of the VBA Application:
How do you think the application of your suggested solution would impact a business or
organisation? Would you, for example, expect it to lead to lower costs, higher efficiency,
higher accuracy, etc.? Discuss the potential implications of implementing your application
within a business or organisation.
Discuss how well you believe your proposed solution is likely to address the problem/issue
and make some suggestions on the how your model’s limitations that you have identified
may be addressed.
4. User’s Operational manual:
Write an operational manual so that a user who is familiar with Excel, but has no knowledge of
VBA, can successfully operate your VBA application. It should be brief: Bear in mind that well-
written software needs less explanation. Note the following:
• Screenshots are not essential, but are useful.
• Any assumptions and limitations should be specified here.
• An explanation of any warnings and/or messages given by the program should be given. It is
not essential, but you might want to combine this with a troubleshooting section.
5. Technical Documentation:
The technical documentation should describe the components of the application to a VBA-literate
reader so that the VBA application can be maintained and enhanced in the future. It should
include:
• The purpose of each file (module, class, UserForm).
• For each file, a brief description of the purpose of each routine, method, properties and
event. This should be no more than a few sentences; often one will suffice.
• A description of how the files are linked together.
6. VBA program code:
Copy and paste the entire text (not a picture) of your VBA code as appendix to the report.
Your report must not exceed 2000 words including everything except the VBA code text,
bibliography and reference list.
Submit to blackboard:
A single pdf document containing (i) your report and (ii) the entire text of your application
VBA code copied from Excel. You must submit the pdf document to the Turnitin submission
tab on blackboard.
An Excel file in xlsm format containing your VBA application. You must submit xlsm file to
the ‘VBA Model Submission’ tab on blackboard.
If your application inputs a data set, for example a csv file, then you must also submit a
sample data file to the ‘VBA Model Submission’ tab so that I can test your application with
the input data.
Hello Majid,
I have read your project brief, Is it an Academic assignment task ? i need some clarifications. Let me discuss more details in Chat. I have 5 years experience in Excel VBA programming and completed 400+ projects. I never ask for payments in front. You can release the agreed milestones once the task is completed and you're happy with [login to view URL] my reviews to confirm my work quality
With Regards,
Sai