Call us today: 0800 028 3045
VBA in Excel Course Part 2 – Spreadsheet Developer
Is it right for me?
Our VBA in Excel Part 2 course is designed for those who are already creating VBA code and need to learn more about what is available and how to use it to create automated solutions.
You must have either attended the VBA in Excel - Part 1 course or have equivalent knowledge.
What will I get out of it?
By the end of the course you will be able to:
- Use arrays to store and re-use data
- Use objects within the Excel Data Model to manipulate information
- Write file search routines
- Create functions
- Create complex user forms
Versions available
2003, 2007, 2010
Related courses in our range
What does it cover?
Comparison operators
- The LIKE function
System functions
- The VAL function
- Case functions
- Trim functions
- Text functions
- Date functions
Excel functions
- Using Excel functions in VBA
Arrays
- Creating arrays
- Using arrays
- Single and multi dimensional arrays
- Static vs dynamic arrays
The Excel object model
- The object browser
- Collections
- Creating object variables
- Setting object variables
The range object
- Creating range objects
- Passing data between range objects and arrays
Working with sheets
- The For Each... Next Loop
- The worksheets collection
- The sheets collection
- Using Typename
Working with workbooks
- The workbooks object
Working with files
- The DIR function
- Searching for files
Working with charts
- The charts collection
- Adding charts
- Amending charts
Creating user defined functions (UDFs)
- Creating functions
- Adding arguments
- Calling functions
Working with Pivot Tables
- The Pivot Tables collection
- The Pivot Cache
- The Pivot Fields collection
- The Pivot Items collection
Application objects
- Excel default information
- Display/alerts
- Screen updating
- Status bar
- On Time
- Using Wait
System dialog boxes
- Showing dialog boxes
- Using dialog boxes
Advanced user forms
- Using combo boxes
- Using check boxes
- Creating and using option groups
- Form interaction
ActiveX controls
- Multi page controls
- Tab strips
- Progress bar
- Spin button
- Calendar
“The course objectives met my mine perfectly, I will be able to use all aspects in future coding. The trainer was very enthusiastic, knowledgeable and eager to help.”
Nick Rafferty, Data Analyst, Canadean
Course Summary
Send to a colleague
Please enter details below and click 'submit'
Tailor this course
If you are interested in this course but would like it tailored to your specific needs, contact Karen Osborn on 0800 028 3045.
Alternatively, enter your details below and one of our team will contact you.
Thales Training & Consultancy is a highly successful training services company based in Crawley. We help companies to develop advantage through learning and development. Highly trusted by leading enterprises, we deliver a full range of dedicated training solutions that enable organisations to achieve key business goals. The 4 core services we offer are Training Courses, Supply Management, Bespoke Services and Managed Services. Our successful partnerships with clients prove that the delivery and management of the right training and development can significantly enhance the pursuit of business excellence.
