Excel VBA Programming
Course Information
This two-day course is designed to introduce and explore the capabilities of Visual Basic for Applications within Excel.
Delegates will learn the basics of structured coding and how to utilise simple forms in application development.
Those attending this course should have a good working knowledge of Excel.
Pre-requisites
Delegates should be comfortable recording Macros, storing the Macros both in the workbook and on the Personal workbook and be able to run the Macros through form controls. Previous experience of programming is not assumed.
Course Objectives
By the end of the course delegates will be able to:
- Recognise the differences between VB and VBA, and the benefits of using VBA coding.
- Take recorded code and using simple VBA techniques, edit, copy and build toggling routines.
- Recognise the object, method and property nature of the Visual Basic language.
- Navigate the various elements of the Visual Basic Editor.
- Name, delete and copy code storage units.
- Create code using decision making and repeating commands.
- Create Message boxes to give users information.
- Create Input boxes to retrieve data during the running of code.
- Utilise variables to temporarily store data during the running of VBA code.
- Build dialogue boxes to control data input.
- Utilise the features within VBA that enable the developer to thoroughly test and debug their coding.
- Build code segments that deal seamlessly with mistakes that a user of coding might make.
- Utilise the Online help facility and the Object Browser.
What you will learn:
Lesson 1 – VB & VBA
The difference between VB & VBA
VBA coding
Lesson 2 – The VB Editor
Use simple VBA techniques,
Edit, copy and build toggling routines.
Navigate the various elements of the Visual Basic Editor.
Lesson 3 – The VB Language
The object, method and property nature of the Visual Basic language
Name, delete and copy code storage units
Create code using decision making and repeating commands
Create Message boxes to give users information
Create Input boxes to retrieve data during the running of code
Lesson 4 – Data Input & Storage
Utilise variables to temporarily store data
Build dialogue boxes to control data input.
Lesson 5 – Data Input & Storage
Test and debug their coding.
Deal with user mistakes.
The Online help facility and
The Object Browse
