The Excel ROMAN Function converts a number value into a Roman numeral. You can use the ROMAN function to convert years into a Roman numeral or create SuperBowl or WWE SuperSlam titles . The ROMAN Function has two parameters: Number and Form. The first parameter is required and the the number to convert into a Roman numeral. [...]
VBA Boolean Data Type Tutorial
The VBA Boolean Data Type stores TRUE or FALSE values. A common use for a VBA Boolean variable is to store a flag to indicate if an action has been performed. The VBA Boolean data type also evaluates to the numerical values 0 (FALSE) or -1 (TRUE), so you may see VBA code with numerical [...]
VBA Variant Data Type Tutorial
The VBA Variant Data Type can hold any type of data: numbers , text or object variables. At first it would seem that a VBA Variant data type is a great innovation: it provides a flexible and versatile way of storing any type of data you want to throw at it. However the Variant variable [...]
Excel VBA Best Practices – Coding Standards – Variables
VBA coding standards and best practices are the key to creating high quality, reliable code while meeting deadlines. Most Excel VBA code found in books ignores coding standards and a a result most of the code found in internet forums is also of questionable quality. The result is that most of the code found in [...]
VBA Double Data Type Tutorial
A VBA Double Data Type is typically used to store numerical values which include fractional values. A VBA double variable is used for prices, coordinates, measurements, and any number that has a fractional component. A VBA Double data type uses 8 bytes (64 bits) of memory. Technically a VBA Double variable holds floating-point numbers ranging [...]
VBA Long Data Type Tutorial
A VBA Long Data Type is typically used to store whole numbers that are too large to be stored in an VBA Integer data type. For example, if you are storing the quantity of large government or commercial orders an integer might not be a good choice because the quantities involved in these orders could [...]
VBA Integer Data Type Tutorial
A VBA Integer Data Type typically stores counters, quantities or as an index within a loop. An Integer variable does not store fractional values, holds whole numbers from -32,768 to 32,767 and uses 4 bytes (16 bits) of memory. Financial information such as prices should not be stored in a VBA Integer variable because it [...]
VBA String Data Type Tutorial
A VBA String Data Type stores text values. Text strings are enclosed in quote characters. For example: Dim sSiteName as String sSiteName = "SpreadSheetSuperStar.com" A computer stores text as a series (or string) of individual “characters”. On a technical level a string is an array of characters. To a computer each character is a number [...]
VBA For Next Loops – Video Tutorial
If you are beginning to record Microsoft Excel macros you probably have discovered how much time you save by recording and playing back keystrokes and mouse clicks – macros are is ideal for automating repetitive, labor intensive tasks such as formatting reports. You quickly discover that clicking on the macro becomes a repetitive and boring [...]
VBA InputBox – Video Tutorial
Looking to add a little bit of WOW to your Microsoft Excel spreadsheet? Perhaps an InputBox is just what the doctor ordered. This video is a quick tutorial on how to use Input Boxes in VBA. Input boxes create that "WOW" factor, but take only seconds to set up and are really easy to use [...]
