Data Types

VBA Variables in Excel

Variables in Excel VBA plays a major role in VBA Programming. Declaring variables helps programmer to avoid mistakes. Let us see the complete tutorial about VBA Variables, syntax and how we can declare variables implicitly and explicitly. Table of Contents: Objective Rules to Naming a Variable in VBA Implicit Variable Declaration in VBA Explicit Variable …

VBA Variables in Excel Read More »

VBA Currency Data Type in Excel

VBA Currency Data Type in Excel

VBA Currency Data Type in Excel 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 contains range of values between -922,337,203,685,477.5808 to 922,337,203,685,477.5807. The data type Currency can be used …

VBA Currency Data Type in Excel Read More »

VBA Object Data Type in Excel

VBA Object Data Type in Excel

VBA Object Data Type in Excel explain 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: Objective Data Type Object Syntax in Excel VBA Example on the Object Data …

VBA Object Data Type in Excel Read More »

VBA Variant Data Type in Excel

VBA Variant Data Type in Excel

VBA Variant Data Type in Excel 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 length string. It is more flexible, but occupies more space in memory. Type declaration character is not …

VBA Variant Data Type in Excel Read More »

VBA String Data Type in Excel

VBA String Data Type in Excel

VBA String Data Type in Excel 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 characters. The string contains double-quotation-mark literal. …

VBA String Data Type in Excel Read More »

VBA Double Data Type in Excel

VBA Double Data Type in Excel

VBA Double Data Type in Excel 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 contains range of values -1.79769313486231E308 to …

VBA Double Data Type in Excel Read More »

Single Data Type in Excel VBA

VBA Single Data Type in Excel

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 contains range of values -3.402823E38 to -1.401298E-45 for negative values, and 1.401298E-45 to 3.402823E38 for positive …

Single Data Type in Excel VBA Read More »

Date Data Type in Excel VBA

VBA Date Data Type in Excel

Date Data Type in Excel VBA explained with syntax and examples. The Date VBA date type stores floating point numbers that represents date and time. We can store date, time or date and time. It has date range values from Jan 1, 0100 to December 31, 9999 and time values from 0:00:00 to 23:59:59. Date …

Date Data Type in Excel VBA Read More »

Decimal Data Type in Excel VBA

VBA Decimal Data Type in Excel

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 type contains range of values +/-79,228,162,514,264,337,593,543,950,335 …

Decimal Data Type in Excel VBA Read More »

VBA Integer Data Type in Excel

VBA Integer Data Type in Excel

VBA Integer Data Type in Excel 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 contains range of values between -32,768 to 32,767. Integers cannot have decimal places. The integer number can be positive number, negative …

VBA Integer Data Type in Excel Read More »