Variables

Currency Data Type in Excel VBA

VBA Currency Data Type in Excel

Currency Data Type in Excel VBA Currency Data Type in Excel VBA explained with syntax and examples. We use the Currency VBA data type to store numbers in integer format and these numbers scaled by 10,000. The default value is 0. The Currency VBA data type conatins range of values between -922,337,203,685,477.5808 to 922,337,203,685,477.5807. The …

Currency Data Type in Excel VBARead More »

Object Data Type in Excel VBA

VBA Object Data Type in Excel

Object Data Type in Excel VBA Object Data Type in Excel VBA explained with syntax and examples. An object consists of reference to an object. It occupies 4 bytes (32 bits) in memory. We use Set statement for a convenient way to refer an object. Table of Contents: Overview of Object VBA Data Type in …

Object Data Type in Excel VBARead More »

Variant Data Type in Excel VBA

VBA Variant Data Type in Excel

Variant Data Type in Excel VBA Variant Data Type in Excel VBA explained with syntax and examples.Variant Data Type in Excel VBA explained with syntax and examples. It is a special and universal data type to use for any kind of data except fixed lenth string. It is more flexible, but occupies more space in …

Variant Data Type in Excel VBARead More »

String Data Type in Excel VBA

VBA String Data Type in Excel

String Data Type in Excel VBA String Data Type in Excel VBA explained with syntax and examples.String Data Type in Excel VBA explained with syntax and examples. Where string is nothing but sequence of characters. We use VBA data type string to store text. Text includes not only characters but also numbers, spaces and special …

String Data Type in Excel VBARead More »

Double Data Type in Excel VBA

VBA Double Data Type in Excel

Double Data Type in Excel VBA Double Data Type in Excel VBA explained with syntax and examples.Double Data Type in Excel VBA explained with syntax and examples. We use VBA data type Double to store numbers which represents Double-precision floating-point variables. The default value is 0 and store decimal values. The VBA data type Double …

Double Data Type in Excel VBARead More »

Single Data Type in Excel VBA

VBA Single Data Type in Excel

Single Data Type in Excel VBA Single Data Type in Excel VBA explained with syntax and examples. We use VBA data type single to store numbers which represents single-precision floating-point variables. The default value is 0 and store decimal values. The VBA data type single conatins range of values -3.402823E38 to -1.401298E-45 for negative values, …

Single Data Type in Excel VBARead More »

Decimal Data Type in Excel VBA

VBA Decimal Data Type in Excel

Decimal Data Type in Excel VBA Decimal Data Type in Excel VBA explained with syntax and examples.Decimal VBA Data Type in Excel VBA explained with syntax and examples. We use the Decimal VBA data type to store integer numbers scaled by a variable power of 10. The default value is 0. The Decimal VBA data …

Decimal Data Type in Excel VBARead More »

Integer Data Type in Excel VBA

VBA Integer Data Type in Excel

Integer Data Type in Excel VBA Integer Data Type in Excel VBA explained with syntax and examples. We use the integer VBA data type to store only integer whole numbers. The default value is 0. The integer VBA data type conatins range of values between -32,768 to 32,767. Integers cannot have decimal places. The integer …

Integer Data Type in Excel VBARead More »

VBA Split String into Array in Excel

VBA Split String into Array

VBA Split String into Array in Excel VBA Split String into Array in Excel is regular task in data analysis. In this tutorial we use Dim statement, VBA Split function, array and Delimiter. Dim statement is used to declare array and string type variable. Here not defining the array size. VBA Split function creates an …

VBA Split String into Array in ExcelRead More »

Environment Variables in VBA

VBA Environment Variables

Environment Variables in VBA We have an environment block that contains a set of environment variables and their values. You can get at all the system information using VBA by using environment variables. Here are the different Environment variables, you can find the below table. These Environment variables especially useful when you want to know …

Environment Variables in VBARead More »