Microsoft Excel Visual Basic
Aims:
To illustrate how to use macro programming to speed repetitive tasks when employing Microsoft Excel
Prerequisites:Delegates MUST be familiar with the use and exploitation of Microsoft Excel at an advanced level
Duration:Three Days
Fees:Course fees for this particular course will depend on your chosen Training solution. Please contact one of our advisors for further details
PDF Course Download
You can download a PDF version of the course.
Download Microsoft Excel Visual Basic course outline.
If you don't have Adobe Acrobat Reader, this can be downloaded from the www.adobe.com web site.
If you are interested in our Microsoft Excel Visual Basic course call us on
0113 243 2226
Enquire about
this course Now
- What is a Macro?
- Assigning Macros to Buttons and Objects
- Editing Macros
- The Range Object
- Workbooks and Sheets
- Objects, Properties and Methods
- Variables and Constraints
- Handling Text
- Conditional Control Structures
- Looping Control Structures
- Controls, Dialogue Boxes and Forms
- Display
- Debugging and Error Trapping
- Function Procedures
- Microsoft Access Recordsets
- Creating Word Documents
- Sending Mail with Outlook
- Naming Conventions
