Create dialog boxes to avoid user-corrupted input cells, ensure no entries are missed and make input clearer.
Use ADO to transfer data to and from databases (the example uses an Access database).
Send emails via Outlook.
Process data much faster with arrays.
Include tables and charts into Word.
Improve your understanding of objects, properties, methods, events, arguments and functions.
Master the full VBE environment to work productively.

Review objects, properties, methods

• Understand object models.
• Test code in the Immediate window.

Work productively in VBE

• Navigate with bookmarks.
• Jump among procedures.
• Select from lists to reduce typing.
• Learn the keyboard shortcuts.
• Discover the Object Browser.

Learn debugging techniques

• Know the keyboard shortcuts to step over and out.
• Use Watches to find where a program is failing.

Know correct range object techniques

• Learn how to make macros work reliably with ranges that are not of fixed size.
• Enter formulas into a range.

Build custom dialog boxes

• Know all the MsgBox and InputBox arguments.
• Restrict the inputs allowed into an InputBox.
• Create a UserForm dialog box.
• Use various controls: option button, check box, label, text box, combo box, list box, multipage.
• Split a dialog box into multiple tabs.
• Create a Wizard to guide the user through steps.
• Set the focus to the control that has an invalid entry.
• Program the UserForm automatic initialisation.

Discover more events

• Use Worksheet and Workbook events to run macros automatically.
• Redefine the behaviour of keys.
• Discover the ActiveX control events.
• Alter the Shape object that applies to ActiveX controls.

Run other programs

• Discover Microsoft Active Data Objects (ADO) to get data from database files.
• Create simple SQL queries.
• Use Outlook to send email.

Know data types and scope

• Know the Visual Basic data types.
• Convert between text and number types.
• See why you should declare your variables.
• Process ranges faster with arrays.
• Learn about scope and variable availability.

Prerequisites

• Excel users who need to create more advanced and user-friendly applications.
• This course is suitable for intermediate-level Excel users who have either attended our two-day Macros introduction course or are competent in its agenda items.

• Be assured the advice you get is well-proven and utilised.
• Feel free to ask questions.
• Get time away from the office and constant interruptions.
• Enjoy a friendly environment where you don’t feel you’re holding others up.
• Instantly apply what you’ve learned on return to work.