The aim of the course is to introduce participants to the use of Visual Basic editor to manage files in Excel. The course will focus on native functions, the procedure management, the use of objects and their grouping.
1. Automation in Excel
• Introduction to macros
• Visual Basic Editor environment
• Libraries in Excel
• The cells, the range and the visibility of the spreadsheet and the workbook
2. Interacting with the worksheet
• Working with the Range tool
• Cut, copy and paste operations on the range object
• The RangeSelection properties
• Adding a comment to a cell
• Formatting cells
• Assigning a formula to cells
• Native functions
3. The code management
• Procedures and subprocedures
• Functions and procedures
• Conditional and cyclical execution of functions
• Creating windows
• Inizializing objects
• Creating objects and groups of objects
• Error management
• Managing and protecting the worksheet and the workbook
Ad hoc
Contatti
