Microsoft Excel includes a comprehensive macro programming language called VBA. This programming language provides you with at least three additional resources:
- Automatically drive Excel from code using Macros. For the most part, anything that the user can do by manipulating Excel from the user interface can be done by writing code in Excel VBA.
- Create new, custom worksheet functions.
- Interact Excel with other applications such as Microsoft Word, PowerPoint, Internet Explorer, Notepad, etc.
VBA stands for Visual Basic for Applications. It is a custom version of the venerable Visual Basic programming language that has powered Microsoft Excel’s macros since the mid-1990s.
Please ensure any examples or topics created within the excel-vba tag are specific and relevant to the use of VBA with Microsoft Excel. Any suggested topics or examples provided that are generic to the VBA language should be declined in order to prevent duplication of efforts.
✓ Creating and interacting with worksheet objects
WorksheetFunctionclass and respective methods
✓ Using the
xlDirectionenumeration to navigate a range
✗ How to create a ‘for each’ loop
MsgBoxclass and how to display a message
✗ Using WinAPI in VBA