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
Meet the Excel Visual Basic Macro Editor
ByRickThe macros you recorded in the previous post are stored in an Excel file. To edit it you use what looks like a separate program, the Visual Basic Editor. Open it with the Developer ribbon (Code group) > Visual Basic Editor (Alt+F11). You will find newly-recorded macros under Modules in the explorer on the left…
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…
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…
Error-Handling in Excel Visual Basic
ByRickIt is difficult to make your program foolproof, because fools are so ingenious! Even so, one should make an effort to trap and handle errors. You should not let the program simply crash if there is a problem, whether due to bad data, faulty calculation, or whatever. This is what we call Error-Handling. Excel Visual…
How to Make Your Own Excel Dialog Box with a Visual Basic UserForm
ByRickThe built-in dialog boxes, MsgBox and InputBox$, are very useful for getting input from the user. But sooner or later you will want to go further. You might, while running code, want the user to make a choice from a list, or between several options. For this, you want a UserForm. For example: The program…
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…