VBA is the abbreviation for Visual Basic for Applications. As the name suggests, VBA comes from Microsoft's Visual Basic language. Avanquest Formation VBA Excel allows you to automate certain tasks in Office applications. This course focuses primarily on using VBA in Excel, but the principles covered apply (except when too specific) to other applications in the suite.
Features of Avanquest Formation VBA Excel
- Use the macro recorder properly
- VBA language instructions
- Error management in VBA
- Code development
- Processing dates
- Use Excel functions in VBA
- Plotting graphics in VBA
- Using ActiveX Controls
- UserForms
- Finding duplicates in a column
- Testing the validity of an email address
- Execute code when opening or closing a workbook
Technical Details and System Requirements
- Supported OS: Windows 10 / Windows 8.1 /Windows 7
- Processor: Multi core Intel Series or above, Xeon or AMD equivalent
- RAM: 4GB (8GB or more recommended)
- Free Hard Disk Space: 4GB or more recommended