VBA deepening for Excel («VBXLS»)

• Deepening your VBA knowledge in Excel
• Creation of own formulas and dialogs
• Programming of the fully automatic generation of reports
• Safe and independent solving of Excel applications from daily practice with VBA in Excel
• Understanding the object model of Excel 
• Stable and secure implementation of your own programs

1. The Excel Object Model
   • The Object Hierarchy
   • The most important Excel objects
   • The most important enumerated objects
   • References to the Active Item
2. Working with cells and ranges
   • Cell and range addressing
   • The Range object
   • The Cells method
3. Working with Tables and Workbooks
   • Response to tables and workbooks
   • Managing Workbooks
4. Error handling
   • Intercept Error
   • Using Visual Basic Test Helps
5. Event-driven programming
   • Event procedures at the table and workbook levels
   • Auto Macros
6. Automate with Excel
   • Simple controls
   • ActiveX Controls
   • Access and control of Excel and dialog boxes
   • Save user settings to the registry
   • Merge data from multiple tables
   • String Functions
7. Forms
   • Using UserForms
   • Definition and programming of controls in forms
   • Read data in forms
   • Save Form Data
8. Text files
   • Distinguishing types of text files
   • Read and write text files
   • Import text files into Excel spreadsheets
9. Improving the duration and stability of the programme
   • Screen update
   • Control of recalculation
10. Practical Tips and tricks

Power users, users and developers who work with Excel already have previous knowledge of VBA and now want to deepen their knowledge of programming Excel.

Excellent VBA skills are required to attend this course. In particular, attendance of the following course with an interval of 4-6 months is required:

This course is also suitable for users of Excel 2013 and 2010.