Microsoft Excel Training Videos
Macros in Microsoft Excel - an interesting example
First you see a worksheet with the legend
The macro code is then displayed as a text file
The code is shown in the Visual Basic Editor
In the Visual Basic Editor click on the run button and follow the data input instructions
You can then see the input and calculated data under the respective column cells
Two methods of accessing cells have been demonstrated - 'Range' and 'Cells'
A 'do while' loop and an 'if' use has been effectively shown
The Microsoft Excel macro calculates the 'perks' and the total 'package'.
Now you can extend this program for your practice
Remember you can 'pause' the Microsoft Excel training video to take a closer look at the code
|
