Add-in Tutorial: Name Manager Plus

Name Manager Plus has been developed by Excel Virtuoso as a new add-in to better manage named range references within an spreadsheet. The add-in permits uses to more easily adjust named range references, names, and permits the assignment of categories.

Overview of Methods and Properties of the Range Object

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.

Data Validation with Excel’s Built-In Data Validation Tools

Many developers will admit that when it comes to creating a user friendly application, more effort is often committed to controlling user inputs than actual functionality and design. Excel’s data validation tools allow you to easily deploy validation features on any spreadsheet project.

Data Input for Datasets in Excel with VBA

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.