FROG Software Training: Excel 2010/2013/2016 VBA
Do you regularly have to carry out the same procedure to organise your worksheets or documents? There is a quicker way, by automating using macros and enhancing with VBA.
|Dates||27 Feb 2019 - 28 Feb 2019 - This event is in the past.|
|Venue||FROG, Great Shelford, Cambridge CB22 5NE|
|Organiser name||Debby O'Gorman|
Description: Delegates will gain a general knowledge of VBA to use within Microsoft Office applications.
Pre-requisites: Delegates should be advanced level users of Microsoft Excel, although no previous programming knowledge is necessary.
What is Visual Basic for Applications?
- An Introduction to Macros
- Recording Macros
- Running Macros
Understanding the Visual Basic Environment
- The Visual Basic Editor
- Understanding the syntax of your Macros
- Editing Macros
- Adding comments and documentation to your macros
- Assigning VBA and Macros to keyboard shortcuts, icons and menus
- With Statements
- Managing Error Messages
- Debugging Techniques
- Working with Variables and Data TypesUser Defined Functions
- Understand Objects and Collections
- Add conditions to your macros
Communicate with the user
- Message boxes
- Input Boxes
- Working with return values
Repeating Actions in VBA – Loops
- Fixed loops
- Flexible Loops
Customise Menus and Toolbars
Automation with Macros
Create Custom Dialog Boxes
Founded in 1986 The FROG Group is recognised for the quality of its services. FROG has been providing computer and personal development training along with consultancy and room hire for over 30 years. The training centre in Cambridge offers a wide range of courses including the latest Microsoft Office, Personal Development, Adobe Creative Suite and many others, and together with partners across the UK FROG can provide all your training needs.