What is the difference between Option Explicit and Option Base?
What are the different data types and their sizes?
What are the Maximum number of rows & columns in Excel?
What are the Security Vulnerabilities for VBA?
Can you define volatile function?
What are the security vulnerabilities for VBA?
How can you format expressions by using VBA?
What are the built-in Class modules?
How to use data validation function in VBA?
Can you explain Function Pointers?
What are the different User Form Controls and ActiveX Controls?
Can you explain Excel Dependency Tree?
How can you add a drop-down list to a cell so the user can choose a value from the list?
Explain What does 'Workbook.ForceFullCalculation' do?
How to assign macros to a button?
How do I stop recording macro?
How do you use the Getsetting and Savesetting functions to read and write registry settings?
What is the basic object model of Excel?
How to create table in the required database using VBA?
How to delete records in the access database table using VBA?
Explain How to move a file from one location to another location?
How to delete table from a specific database using VBA?
How to create a new word document using VBA?
Excel VBA – DataTypes
Data Type |
Bytes Used |
Range |
Byte | 1 byte | 0 to 255 |
Integer | 2 bytes | -32,768 to 32,767 |
Long (long integer) | 4 bytes | -2,147,483,648 to 2,147,483,647 |
Single | 4 bytes | -3.402823E38 to -1.401298E-45 for negative values; 1.401298E-45 to 3.402823E38 for positive values |
Double | 8 bytes | -1.79769313486231E308 to-4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values |
Currency | 8 bytes | -922,337,203,685,477.5808 to 922,337,203,685,477.5807 |
Decimal | 14 bytes | +/-79,228,162,514,264,337,593,543,950,335 with no decimal point;+/-7.9228162514264337593543950335 with 28 places to the right of the decimal |
Boolean | 2 bytes | True or False |
Object | 4 bytes | Any Object reference |
Date | 8 bytes | January 1, 100 to December 31, 9999 |
String (variable-length) | 10 bytes + string length | 0 to approximately 2 billion |
String (fixed-length) | Length of string | 1 to approximately 65,400 |
Variant (with numbers) | 16 bytes | Any numeric value up to the range of a Double |
Variant (with characters) | 22 bytes + string length | Same range as for variable-length String |
User-defined | Varies | The range of each element is the same as the range of its data type. |