This program is for high-end users who want to make the most of the power of Microsoft Excel. It introduces programming techniques and concepts such as variables, scoping, importing data, passing values and debug techniques. If you have experience with the macro recorder and introductory programming, you will benefit from this program.
This program provides instruction in the more advanced use of Excel Macros. It will take participants beyond our Excel - Macros with VBA Programming and introduces techniques for high-end Excel users to better utilise the power of Excel.
Participants should be able to:
- Have a deeper understanding of the Visual Basics Editor (VBE) environment
- Work with variables
- Understand scoping
- Pass values between procedures
- Import data from external sources
- Create better user forms
- Use debug techniques
- Use other objects.