Excel Visual Basic Variables, Part 1: Variable Types

ByRick

Subscribe to continue reading

Subscribe to get access to the rest of this post and other subscriber-only content.

Similar Posts

| |

How to Use a Worksheet Function in a Macro: Proper Case Names

ByRick

In some cases, VBA does not have a specific function, but the Excel Worksheet does. This Excel Visual Basic (VBA) code example demonstrates: How to call that Worksheet Function from a Macro. In this particular example, how to call the Worksheet Function =PROPER() from VBA. The function to downcase parts of surnames that normally appear…

|

A List of the Excel Visual Basic Editor Shortcut Keys

ByRick

While you can pick these Shortcut Keys up from the menus in the Excel Visual Basic Editor, it is useful to have them all in one place. F1                         Help on the highlighted itemF2                         Object BrowserShift+F2               View Definition (Go to highlighted Sub or Function)F3                         Repeat last FindF4                         Display Properties WindowF5                         Run / Continue RunF8                         Single Step…

| |

Built-in Functions in Excel Visual Basic for Applications (VBA)

ByRick

Before Excel 2003, you could get a complete list of Visual Basic Functions by looking in Visual Basic Help > Contents > Functions. In Excel 2010, entering “Functions” into the Help Search box produces nothing useful.  Using a specific category, e.g. “Math Functions”, may be more productive.  Please be aware of what references to “Excel…