Interview Questions

VBA Interview Questions and Answers

VBA Interview Questions and Answers

Interview Questions August 28, 2019

VBA Interview Questions and Answers

VBA Interview Questions and Answers for beginners and experts. List of frequently asked VBA Questions with answers by Besant Technologies. We hope these VBA interview questions and answers are useful and will help you to get the best job in the networking industry. These VBA interview questions and answers are prepared by VBA Professionals based on MNC Company’s expectations. Stay tuned we will update New VBA Interview questions with Answers Frequently.

Besant Technologies supports the students by providing VBA interview questions and answers for the job placements and job purposes. VBA is the leading important course in the present situation because more job openings and the high salary pay for this VBA and more related jobs.

Best VBA Interview Questions and Answers

Here is the list of most frequently asked VBA Interview Questions and Answers in technical interviews. These VBA questions and answers are suitable for both freshers and experienced professionals at any level. The VBA questions are for intermediate to somewhat advanced VBA professionals, but even if you are just a beginner or fresher you should be able to understand the VBA answers and explanations here we give.

In this post, you will get the most important and top VBA Interview Questions and Answers, which will be very helpful and useful to those who are preparing for jobs.

Q1) Give the abbreviation for VBA?

VBA – Visual Basic Applications

Q2) Provide some of the data types

Some of the data types are Object, Date, Integer, String, Byte, Long, Single, Variant, Boolean, Currency, Double, LongPtr, and LongLong.

Q3) Explain Variant data type

A variant can get hold of any data type and this is the default data type.

Q4) What are the levels where we can define a variable?

Global Level, Module Level, and Local Level are the levels where we can define a variable.

Q5) Provide the different core module types existing in VBA

User Forms, Code Module, and Class Modules are the different core module types existing in VBA.

Q6) Can you mention the difference between Functions and Procedures?

Functions return values, whereas Procedures never return a value.

Q7) Mention the built-in class modules

Worksheet and Workbook modules are the built-in modules.

Q8) Give the shortcut key to access the editor screen

Alt+F11 key is used to access the editor screen.

Q9) Mention all the looping statements available in VBA

The most important looping statements available in VBA are For, Do, Until, Next, While, and Wend.

Q10) List out the various UserForm Controls of VBA

Spin Button, Label, Combo Box, Scroll Bar, Button, Spin Button, Group Box, CheckBox, List Box, Option Button are some of the UserForm Controls of VBA.

Q11) List out the various ActiveX Controls of VBA

Spin Button, CheckBox, Command Button, Option Button, Toggle Button, Image, Text Box, List Box, Label, Scroll Bar, and Combo Box are some of the ActiveX Controls of VBA.

Q12) Provide the different error handling techniques

On Error Goto Err_Lbl, On Error Resume Next, and On Error Goto 0 are the three (3) error handling techniques in VBA.

Q13) What are the two methods to check whether the file existing in a specific location or not?

Dir function and FileSystemObject are the two methods used to check whether the file existing in a specific location or not.

Q14) How will you count a string?

CountA is the method used to count a string.

Q15) Provide the shortcut for referencing the cell

The shortcut to reference the cell in VBA is ‘Fn+F4’.

Q16) Explain Round function in VBA

For the given number of digits, Round function returns a rounded number.

Q17) Explain sparklines in excel

In a cell, we can see a tiny chart that provides a visual representation of data. That is called sparklines in Excel

Q18) What is the purpose of using Hyperlink in Excel?

Hyperlink is used to take the user to the given destination.

Q19) Is it possible to call UDF in a macro?

Yes, it is possible to call UDF in macro.

Q20) Describe ReDim

To size or resize a dynamic array which are declared already, ReDim is used.

Q21) How will you add comments in Excel VBA?

To add comments in Excel VBA, you can use an apostrophe.

Q22) Do you think Dictionary structure is available in VBA?

Yes, VBA has Dictionary Structure.

Q23) Give the abbreviation of ADO

ADO stands for ActiveX Data Objects

Q24) Give the abbreviation of ODBC

ODBC stands for Open Database Connectivity

Q25) How will you reduce the reference counter explicitly?

Set a variable as ‘Nothing’ to reduce the reference counter explicitly.

Q26) Give the abbreviation for COM in VBA

COM stands for Component Object Model, which are compiled executable programs.

Q27) What are the two (2) methods to pass arguments in VBA?

ByRef and ByVal are the two (2) methods to pass arguments in VBA.

Q28) Provide the difference between Functions and Subroutines in VBA.

Functions return values, whereas subroutines do not return any values. Function will not modify the actual arguments value, whereas subroutines can change the actual argument values.

Q29) At runtime, which menu property cannot be set in VBA?

Name property cannot be set at runtime.

Q30) What are the two (2) states of Boolean Data Type in VBA?

The two (2) states of Boolean Data type are True and False.

Q31) Is it possible to increase the row count in a worksheet?

No, it is not possible to increase the row count in a worksheet.

Q32) Provide the abbreviation of OLE

OLE stands for Object Linking and Embedding

Q33) Through VB, in excel, how will you set custom paper size?

To set the custom paper size in Excel, use ‘Activesheet.PageSetup.PaperSize = xlPaperLetter’.

Q34) Which macro language is used in the current days?

XLM was used in 1997 and before. VBA is the currently used language.

Q35) Provide the various error types in VBA

The three (3) types of errors in VBA are Runtime, Syntax and Logic.

Q36) In VB, is it possible to create cgi scripts?

Yes, we can create cgi scripts in VB.

Q37) Provide the list of dialog box available in VB

User Defined, Predefined and Custom are the three (3) types of dialog box available in VB.

Q38) List out the scopes of the class in VB

Friends, Public and Private are the class scopes in VB

Q39) Provide the Validations types in VB

Form and Field are the two (2) types of Validation in VB

Q40) Give the abbreviation for Mapi

Mapi stands for Messaging Application programming Interface

Q41) List out the Style Properties available in List Box of VB

Extended, Multiple Select, Simple Single Select are the style properties available in List Box of VB.

Q42) Provide the tool which is helpful in configuring the Protocols and Port Range

The tool ‘DCOMCONFIG.EXE’ is helpful in configuring the Protocols and Port Range.

Q43) To run the VB, which Dll is required?

To run the VB, Vbrun300.dll is required.

Q44) Provide the advantage of using Mts in VBA

Advantages of using Mts are given below:

  • Deployment
  • Database Pooling
  • Remote execution
  • Transactional Operations
  • Security
Q45) Provide the difference between MsgboxQ function and Msgbox Statement

In VB, the user defines the MsgboxQ function, whereas VB has a built-in function called Msgbox.

Q46) List out the cursor types in ADO

Keyset, Forwardonly, Dynamic and Static are the four (4) cursor types in ADO.

Q47) List out the Locking types in ADO

lockbatchoptimistic, look pessimistic, Lockreadonly and lockoptimistic are the four (4) locking types in ADO.

Q48) What are the controls that have a refresh method in VBA?

Label, Listbox, button, Datagrid, and Combobox are the controls that have a refresh method.

Q49) What are the controls that have a clear method in VBA?

The textbox is the control that has a clear method.

Q50) How will you compress an image in image control of VBA?

Use ‘Stretch’ to compress an image.


Besant Technologies – Chennai & Bangalore Branch Locations

Besant Technologies - Velachery Branch

Plot No. 119, No.8, 11th Main road, Vijaya nagar,

Velachery, Chennai - 600 042

Tamil Nadu, India

Landmark - Reliance Digital Opposite Street

Besant Technologies - Tambaram Branch

No.2A, 1st Floor, Duraisami Reddy Street,

West Tambaram, Chennai - 600 045

Tamil Nadu, India

Landmark - Near By Passport Seva

Besant Technologies - OMR Branch

No. 5/318, 2nd Floor, Sri Sowdeswari Nagar,

OMR, Okkiyam Thoraipakkam, Chennai - 600 097

Tamil Nadu, India

Landmark - Behind Okkiyampet Bus Stop,

Besant Technologies - Porur Branch

No. 180/84, 1st Floor, Karnataka Bank Building,

Trunk Road, Porur, Chennai - 600 116

Tamil Nadu, India

Landmark - Opposite to Gopalakrishna Theatre

Besant Technologies - Anna Nagar Branch

Plot No:1371, 28th street kambar colony,

I Block, Anna Nagar, Chennai - 600 040

Tamil Nadu, India

Landmark - Behind Reliance Fresh

Besant Technologies - T.Nagar Branch

Old No:146/2- New No: 48,

Habibullah Road,T.Nagar, Chennai - 600 017

Tamil Nadu, India

Landmark - Opposite to SGS Sabha

Besant Technologies - Thiruvanmiyur Branch

22/67, 1st Floor, North mada street, Kamaraj Nagar

Thiruvanmiyur, Chennai 600041

Tamil Nadu, India

Landmark - Above Thiruvanmiyur ICICI Bank

Besant Technologies - Siruseri Branch

No. 4/76, Ambedkar Street, OMR Road, Egatoor, Navallur,

Siruseri, Chennai 600130

Tamil Nadu, India

Landmark - Near Navallur Toll Gate, Next to Yamaha Showroom

Besant Technologies - Maraimalai Nagar Branch

No.37, Ground Floor, Thiruvalluvar Salai,

Maraimalai Nagar,Chennai 603209

Tamil Nadu, India

Landmark - Near to Maraimalai Nagar Arch

Besant Technologies - BTM Layout Branch

No 2, Ground floor, 29th Main Road,

Kuvempu Nagar,BTM Layout 2nd Coming from Silkboard,

AXA company signal, Stage, Bangalore - 560 076

Karnataka, India

Landmark - Next to OI Play School

Besant Technologies - Marathahalli Branch

No. 43/2, 2nd Floor, VMR Arcade,

Varthur Main Road, Silver Springs Layout,

Munnekollal, Marathahalli, Bengaluru - 560037

Karnataka, India

Landmark - Near Kundalahalli Gate Signal

Besant Technologies - Rajaji Nagar Branch

No. 309/43, JRS Ecstasy, First Floor,

59th Cross, 3rd Block, Bashyam Circle,

Rajaji Nagar, Bangalore - 560 010

Karnataka, India

Landmark - Near Bashyam Circle

Besant Technologies - Jaya Nagar Branch

No. 2nd Floor,1575,11th Main Road,

4th T-Block, Pattabhirama Nagar,

Jaya Nagar, Bangalore - 560 041

Karnataka, India

Landmark - Opposite to Shanthi Nursing Home

Besant Technologies - Kalyan Nagar Branch

No.513, 4th Cross Rd

2nd Block, HRBR Layout,

Kalyan Nagar, Bangalore - 560 043

Karnataka, India

Landmark - Opposite to kalayan nagar Axis Bank

Besant Technologies - Electronic City Branch

No. 7, 3rd Floor, Ganga Enclave,

Neeladri Road, Karuna Nagar, Doddathoguru Village,

Electronics City Phase 1, Electronic City,

Bangalore - 560100, karnataka, India

Landmark - Adjacent to HDFC Bank and State Bank Of India

Besant Technologies - Indira Nagar Branch

No.54, 1st Floor,

5th Main kodihalli,

Bengaluru, Karnataka 560008, India

Landmark - Behind Leela Palace Hotel,

Besant Technologies - HSR Layout Branch

Plot No. 2799 & 2800, 27th Main,

1st Sector, HSR Layout,

Bengaluru, Karnataka 560102, India

Besant Technologies - Hebbal Branch

No.29, 2nd Floor, SN Complex,

14th Main Road, E-Block Extention, Sahakara Nagar,

Bengaluru, Karnataka -560092, India

Scroll Up