|
|
|
|
Macros next step - agenda
|
| Format: fully hands-on - computers will be provided |
| Duration: two days |
| Arrival and refreshments: 9:00 am |
|
Start: 9:15 am |
|
Finish: 4:30 pm |
|
|
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 formulae 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.
|
|
Automatically display custom toolbars
- Use custom toolbars for maximum user convenience.
- Display and remove custom toolbars automatically.
- Select an icon from the hundreds available.
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.
Learn various useful features
- Protect your macros from prying eyes.
- Discover the Select Case statement.
- Use the Parent property to make applications more robust.
- Learn a number of useful VBA functions such as Dir, InStr, StrComp, CDate,
CDbl, Format, IsEmpty, IsNumeric, IsError, Left, Mid, Right, UBound.
|
|
|
|
Who should attend:
- 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 introductory course or are competent in its agenda items.
- You should be familiar with For loops, If…Then…Else, and the Range object.
|
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.
The courses cover Microsoft Excel releases XP(2002) through 2010.
Where there are differences among the covered releases, they are pointed out.
Course cancellation policy:
A course booking is considered final when an invoice is sent, 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.
|
|