Excel Visual Basic Variables, Part 2: Declaring and Naming Variables, Scope and Lifetime
Subscribe to continue reading
Subscribe to get access to the rest of this post and other subscriber-only content.
Similar Posts
How to Store Program Settings in the Registry from Excel Visual Basic
ByRickWindows stores program settings in the Registry, a Windows internal database. You can use this to remember previous user choices and use them as defaults the next time. We typically remember window positions, file paths, and other settings with the Registry. These three commands work with items stored in the Registry: SaveSetting appname, section, key,…
How to Work with Files in Excel Visual Basic
ByRickYou can use Excel Visual Basic to read and write text files (Sequential and Random file access). But we will not touch on text files in this post. Rather, we will look at how to save and open Excel files using Excel code, plus a few valuable functions: The bigger examples below are in the…
How to Use a Worksheet Function in a Macro: Proper Case Names
ByRickIn 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…
How to Write a Visual Basic Function Procedure
ByRickThis is from Microsoft Excel 2000 Visual Basic Help, with changes and additions. A Function procedure is a series of Visual Basic statements enclosed by the Function and End Function statements. A Function procedure is like a Sub procedure, but a function can also return a value. A Function procedure can take arguments, such as…
How to Use Objects, Properties, Methods, and Events in Visual Basic
ByRickThis is an excerpt from Microsoft Excel 2000 Visual Basic Help. 1. Objects and Collections An object represents an element of an application, such as a worksheet, a cell, a chart, a form, or a report. In Visual Basic code, you must first identify an object. Only then can you apply one of the object’s…
Built-in Functions in Excel Visual Basic for Applications (VBA)
ByRickBefore 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…