A Growing List of Functions for Excel VBA
VBA Functions/Subroutines:
- Change Cell Colors: Change the background, font, or border color of cells using Excel VBA
- Delete Entire Rows and Columns: Delete columns and rows using Excel Visual Basic
- FollowHyperlink(): Open files and web pages. Activate Excel Cells from different Excel documents.
- Input Boxes: Get user free-form input
- InStr() Function: Find a string within another string
- Messages, Pop-ups, and Alerts – MsgBox(): Shows different uses for message boxes and pop-up boxes in Excel VBA
Selenium Basic Functions/Subroutines: Excel Reference Library
- Selenium Basic: Web Browser Navigation: Navigate a web browser using Excel Visual Basic
Additional Excel Resources:
- Color Options: Options for colors in Excel VBA programming
- Excel Short Cut Keys: Shortcut key options for Excel