Training Course Fact Sheet:
Microsoft Excel Macros

The course is intended for Excel users who have a thorough knowledge of Microsoft Excel, and now wish to be able to program their own time-saving applications.

Scheduled Courses:

Venue: Live Online via Zoom.  85-page PDF manual is supplied, and valuable examples.
Early-Bird Price if paid not later than two weeks before the course: Only R4,500 plus VAT per trainee.
Thereafter R5,000 plus VAT each.

Course Creator and Facilitator: Rick Raubenheimer B Sc (Eng) (Wits) (1975).

For more information and to book a course online or in-house at your company, click here and send the resulting email or email info@softwareafrica.co.za

Are you unable to attend live?  Or you find the live course too expensive?  We understand.  Take our self-paced online course in your own time at a fraction of the price.  No live support, however.

Who should attend?

Experienced Excel users who now wish to be able to program their own applications.

Essential: A working knowledge of Microsoft Windows and an advanced understanding of Excel.

Duration

Two days.  Note: This is an intensive working course: Delegates who are just looking for a two-day holiday from the office are strongly advised to stay at work.

Content

The course consists of the following sections:

• Introduction to Macros: Recording a Macro, Running a Macro, the Visual Basic Editor, Modifying Visual Basic Code
• Programming Basics, The Sequential Program vs. Event-driven Programming, Program Structure.
• Procedures: Subprograms and Functions.
• Variable Types, Declaring Variables, Arrays, Naming Variables, Scope and Lifetime of Variables
• Program Flow Control: Structured Programming
• Talking to the User: Message Box and Input Box
• Error-Handling
• The Visual Basic Editor in detail
• Projects, Forms and Modules
• Using Help
• Debugging and Testing Code
• Break Mode and Breakpoints; The Debug Window
• Formulae and Built-in Functions; Format$, Immediate IF
• Visual Basic and Excel Objects
• Properties, Events and Methods
• Running Code from a Worksheet:
• Forms Buttons, Toolbar Buttons and ActiveX Buttons,
• Attaching Visual Basic Code to a Button,
• Other Controls.
• Visual Basic Forms as Dialog Boxes, Working with UserForms:
• File Handling.

After the course, trainees have three months' free support by e-mail, WhatsApp, Telegram app, and telephone on the course content, and a free subscription to the monthly Software Africa e-newsletter.

Trainees who wish to go further may also be interested in our two-day course on Advanced Programming Excel Macros.

The online version of this course is available to attendees as a refresher.

The content of this course can be customised to suit customer requirements.

Bookmark this page for future reference!

Press Ctrl+F to search this page for keywords. Search this site: using Custom Search