Fresh Excel Tips

In this article, we will be discussing how to create a new Class Module in VBA and add our object properties and methods. First, for those of you not familiar with object-oriented lingo, an object is a code construct comprised of properties and methods. Properties are variables that describe the object in some way; [...]

In Excel, Data Entry Rules can be used to restrict data that is entered to ensure that it is in the correct format. That data can be restricted to just whole numbers, decimals, dates, times or even a specific length. Also, you can specify whether the values need to be between, not between, equal to, [...]