Excel Visual Basic Variables, Part 1: Variable Types
Subscribe to continue reading
Subscribe to get access to the rest of this post and other subscriber-only content.
Similar Posts
Details of The Excel Visual Basic Editor
ByRick
The Excel Visual Basic Editor can be set to appear in a variety of ways. In the appearance shown below (the default) the majority of windows appear docked at one edge of the screen. Code windows can be tiled together on the screen, or one can be maximized. The main features of the screen are…
More Excel Visual Basic Programming Basics
ByRick
In this post, we will give you some more of the basic (forgive the pun) building blocks of the Visual Basic programming language. We will cover formulas, assigning values, logical comparison, constants, comments, and continuation lines. We conclude with two small examples. One of them demonstrates our first Error Trap. 1. Formulas We have already…
How to Copy Text to and from the Clipboard in Excel and Access Visual Basic
ByRick
You can record a macro to copy from and paste to the Excel worksheet. Easy enough. But what if you have a value in Microsoft Excel VBA that you want to put on the clipboard for another program? Or you want your code to get text from the clipboard after you copied it there from…
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…
How to Use Objects, Collections, Properties, Events and Methods in Excel Visual Basic
ByRick
1. What are Objects and Collections? Visual Basic defines a number of what it calls Objects. Examples of Objects are: In object-orientated terminology, Objects belong to Classes. Collections are groups of Objects. Here are some examples of Collections that Visual Basic defines: 2. The Excel Object Model Excel, too, has objects of its own. When…
How to Run VBA Code from an Excel Worksheet
ByRick
1. What are Controls? First, some terminology. If you wanted to run a macro from a worksheet, you could create a button on the worksheet for the user to click. Such a button is a Control. There are many types of controls, which we will use in a later post. Apart from Command Buttons to…