Excel VBA Interview Questions and Answers

Excel VBA Interview Questions and Answers

What is VBA?

What is a Macro Code?

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 is ADO, OLEDB & ODBC?

What are the Security Vulnerabilities for VBA?

What is Option Explicit?

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?

Can you explain COM add-ins?

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 fasten the VBA macro?

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?

How to debug a VBA code?

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 register a component?

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.