Form and ActiveX Controls provide a user-friendly way to initiate Excel macros, but it may not always be clear to the user that a button needs to be clicked. If you find yourself including notes such as “please click button here”, you may want to consider Worksheet and Workbook events …
Here’s an easy way to annoy your accounting department. For this April Fools Day, I am introducing a new template: Garbage Financial Statement.
Up until this point of the series, the Sub statement–short for subroutine–has been one of the most frequently used statements in tutorials and exercises. In their plain vanilla form, a subroutines serve one purpose — to contain procedural code. However, having a comprehensive understanding of how subroutines work and various …
While the previous post explained how to use conditionals to execute specific blocks of code, the conditions were relatively strict, relying on single variables or liberal values. This post provides an overview of how to incorporate logical operators into conditional statements, permitting much needed flexibility with complex testing.
If you’re interested in learning VBA, that means you want to write scripts that interact with a spreadsheet. The foundation of this interaction is the Range Object. The Range Object contains all the necessary features and tools to make your VBA scripts speak to a spreadsheet.
Visual Basic for Applications, usually identified as VBA, is the programming language in Microsoft Excel. This post examines some of the basic concepts and components encountered as a VBA coder.
One of the great things about Excel is the ability to begin writing VBA code with as few as two clicks upon opening a new workbook. This ease of access allows almost anyone to become a programmer. This post will provide a general tour of the VBA editor.
While Excel provides the means of entering data directly into datasets, you can build important controls and features by processing data through a VBA script. This post will provide an overview of a user-friendly data input form to prepare data for processing and entry in VBA.
Using VBA to control navigation elements of a spreadsheet provides a greater level of flexibility. Through proper coding, users will be provided with responsive navigation and proper feedback.