Using
Microsoft
Excel VBA to
create
software
which can
analyze and
report
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Microsoft Excel and VBA, Exercises of MS Microsoft Excel skills
Visual Basic , giving details on VBA and its usage
Typology: Exercises
2019/2020
1 / 5
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Microsoft Excel and VBA and more Exercises MS Microsoft Excel skills in PDF only on Docsity!
Using
Microsoft
Excel VBA to
create
software
which can
analyze and
report
business
performance
at any time.
HERE IS HOW TO CREAT THIS SOFTWARE:
Let’s begin;
Open a New Excel workbook.
To crate this menu-
TRANSACTION MANAGER CUSTOMER INVOICE ADD CUSTOMER RUN SALES REPORT CUSTOMER INFO
- Highlight B2 to E8,
-Choose ‘Borders’ *Under the Box named ‘line’, you will find the menu ‘style’ -Choose the lighter line *by the right you find the Box named ‘Border’ -Click the four borders of the cells -leave the ‘colour’ setting to be ‘Automatic’. -click ‘ok’ and exit.
- Name the cells just as it is in the photo
- Go to Google, download a pointer photo that fits your software
- After downloading, Open the photo using ‘paint’, crop the photo and click ‘copy’
- Paste it in your workbook as your software pointer buttons
- Make 4 duplicates of it just the way it appears in the photo above.
- Below on your worksheet , you will find your sheet tabs, -Ensure that you create 4 tabs -Rename the tabs accordingly; (Control, invoice, report, cusinfo). Note: to rename tabs- place your mouse pointer on the tab, right-click your mouse and choose ‘Rename’.
COME ONLINE TO DOWNLOAD NEXT TEACHING