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
Start Programming Excel: An Introduction to Macros
ByRickA Macro is a computer program that can duplicate actions you take in a spreadsheet. Macros perform key tasks faster. They can have a short-cut key combination to run them easily. Creating Excel and Word Macros is easier than most other methods of programming. You simply record the actions you took in the program. You…
How to Record a Macro in Excel (or Microsoft Word)
ByRickThe easiest way to create a macro is: The instructions below are for Excel. Word is similar, but has its own quirks (and no “Absolute or Relative”). If you want to look at programming basics first, see this previous post. 1. Recording a Macro Absolute or Relative What does that mean? When you record Absolute,…
A List of the Excel Visual Basic Editor Shortcut Keys
ByRickWhile 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…
FORMULATEXT to Display the Formula in a Cell
ByRickHere is a function that displays the formula in another cell: FORMULATEXT(reference). The argument, “reference”, is the cell address that contains the formula you want to display. This is most useful for documentation purposes. For example, when you want to print out a spreadsheet with its formulas. If you have spent much time on this…
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…