Basic VBA Interview Questions and Answers
Here are the most commonly asked Basic VBA Questions and Answers covered from Basics of VBA Programming.
- What is VBA?
- VBA stands for Visual Basic for Applications.
- VBA is Programming language available in MS Office Tools.
- What are Data-types?
Data types helps to declare Variables with specific data, this helps to VBA to know the type of the data and assign the memory based on the DataType of the Variable. - Name some data types?
Boolean
Byte
Currency
Date
Double
Integer
Long
LongLong
LongPtr
Object
Single
String
Variant - What is Variant Data Type and Explain it?
Variant data type is default data type and it can hold any type of data. This will allocate maximum memory to hold the Varian Type. We use Variant data-type when we dot know the type of the data or to accept the multiple data types in a single variable. - What are Scope of Variables?
We can define variable in different levels:
Local Level: Variables which are defined with DIM statement in a procedure or functions
Module Level: Which are defined with DIM statement on top of a module, can be accessed in entire module
Global Level: Which are defined Public statement at top of any module, can be accessed in entire project.
Mr. Excel
ConstructionOfficeOnline.com recommends MrExcel.com as one of the largest resources for information about Excel.