Working with Numbers || Excel VBA Master Class || 3.4b
Working with Numerical Types can be daunting since there our a lot of options to choose from. We will discuss which option to use when and how to make that decision easy. We will also, look at how to validate whether a value is numerical or not, and how to perform operations such as Addition in VBA.
In this short lesson, we will look at the functions to evaluate numerical values such as isNumeric(), isEmpty() and isNumber(). We will learn about Order Precedence while using Arithmetic Operators.
#vba #excel
Follow the rest of the series, in the below playlist:
• VBA MasterClass
Code snippets can be found here:
https://skillsandautomation.com/maste...
00:00 Intro
00:20 Basics
03:44 Curious Case of the Decimal
04:40 Checking if Number
08:01 Arithmetic Operators
