Select case statements are sequences of VBA statements that behave similar to an If-ElseIf-Else statement. While they are similar in terms of functionality, they can provide clearer and more readable code.
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.
Previous posts on the Getting Started with VBA Series have focused on how to both extract information from cells on the spreadsheet, and create information in VBA with variables. While these may meet the needs of some simple programs, conditional statements open the door to creating responsive programs.
You are likely already familiar with many functions–such as ROUND or TRIM–that can be applied to cell values within a worksheet. VBA also contains a number of string and numeric functions that can be applied to variables.
It’s worth taking a deeper look at the Range object, as it is a central element to reading, writing, and modifying data on a worksheet. This post uses a classic speed test to time the most efficient method of interacting with a spreadsheet.
When coding in VBA, the range object offers a means to fully interact with cells on a spreadsheet. This is done through its object methods and properties — nearly every action undertaken in the Excel interface has a equivalent method or property in VBA.
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 one of Excel offers users the ability to interact with and modify any area of a spreadsheet, there are times where you may not want users of your spreadsheet application to inadvertently change contents. The ability to protect certain parts of a spreadsheet allows for full control, while providing …