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…
Examples of Visual Basic Code for Controlling Excel
ByRick
A major reason to program Excel Macros is to get the spreadsheet to do something. This post is a goldmine of useful Excel Visual Basic code for talking to Excel. You can get use the routines stand-alone. Alternatively, you can save retyping or copy-pasting: Get the file Macros.xlsm free of charge from us. 1. Table…
How to Get Help in the Excel Visual Basic Editor
ByRick
At this point, you might be wondering, “What if I get stuck?” Fear not, help is at hand! Microsoft offers extensive online documentation of the VB language. To be fair and warn you, it’s often not that useful. You might find more assistance if you Google for your topic. There is a lot of programming…
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…
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…