The speaker in this video introduces the concept of macros used in Excel, very simply and lucidly. Two sets of shortcut keys are used, one set to create the macro and the other set to run it. The first shortcut opens up the VBA window (Alt+F11), with a workbook along with the 3 default sheets. This video puts the macro in a module. The procedure starts with typing sub and a name which can be easily recalled. The rules for naming the macro are also covered briefly. After the macro code is written, which has been kept very simple, the macro is recalled from Excel by using Alt+F8 keys and the name of the macro. Very easy to do!
Home
Microsoft Office How to Write a macro by hand in Excel for beginners
![](https://assets.content.technologyadvice.com/thumbnail_Logos_Wonder_How_To_color_light_21e00e7b4a.webp)
By rawhy
Apr 17, 2010 05:21 AM
![Article cover image](https://assets.content.technologyadvice.com/634753643852369854_460b5a9566.webp)
Just updated your iPhone? You'll find updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.
Comments
No Comments Exist
Be the first, drop a comment!