Microsoft Excel specialists

Excel training courses

See dates of all courses
Contact us

  


Related Courses
Macros introduction
Macros advanced
Speed up with macros ?introduction 1-day


  WHAT YOU GET

Course manual
& Excel files

40  minutes’
hotline time

Excel expertise
28 years’
specialisation

Macro-writing courses

Macros next step

     Duration: 2 days  
     Format: Fully hands-on  
   Arrival and refreshments: 8:45am  
   Start 9:00am  
   Finish: 4:30pm  

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.

  YOUR POWER-PACKED AGENDA

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.

  LEARN IN A POSITIVE ENVIRONMENT
 
  • 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.

Presenters

AbleOwl has a number of different presenters, all of whom are Excel specialists.

See dates of all courses  

  COURSE CANCELLATION POLICY
 
A course booking is considered final when received in writing (online, email, fax or post) by AbleOwl, and can be cancelled up to ten working days before the course. After that, payment is expected in full and no refund will be given. All cancellations must be notified in writing, i.e. post, fax or email. Another delegate may be substituted at any time.