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
Examples of Visual Basic Code for Controlling Excel
ByRickA 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…
Details of The Excel Visual Basic Editor
ByRickThe 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…
Visual Basic Naming Rules and Tips
ByRickThis is an excerpt from Microsoft Excel Visual Basic Help, with tips and corrections. Use these rules when you name procedures, constants, variables, and arguments in Visual Basic: 1. Capitalization and Case-Sensitivity Visual Basic isn’t case-sensitive, but it preserves the capitalization in the statement where the name is declared. If you declare variables with the…
Other Form Controls in Excel Worksheets
ByRickIn our previous post, we looked at connecting VBA code to command buttons on the Worksheet, the Quick Access Toolbar and the Ribbon. What about the other Form Controls: The Combo Box, List Box, or Check Box? How about Option Buttons, the Scroll Bar, the Spin button, the Label, etc.? That’s coming up in this…
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…
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…