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 Iterate for a Solution with an Excel Macro: The Manning Formula for Open-Channel Flow
ByRickThe Manning formula for open-channel flow is: whereV= Velocityn = Manning’s “n”,r = Hydraulic radius = area / wetted perimeter = b*y / (2*y + b) for a rectangular channel (where y = depth and b = width), ands = slope of channel (m/m). Discharge Q = V*A = V*b*y. We cannot solve this…
How to Copy Text to and from the Clipboard in Excel and Access Visual Basic
ByRickYou 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 Objects, Collections, Properties, Events and Methods in Excel Visual Basic
ByRick1. 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 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 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…
How to Control Program Flow in Excel Visual Basic
ByRickIn Alice in Wonderland by Lewis Carroll, at the trial of the Knave of Hearts, the White Rabbit asks the King how to read the evidence. “Begin at the beginning, the King said, very gravely, and go on till you come to the end: then stop.” It would be easy if all computer programs did…