EXCEL VBA INTERVIEW QUESTIONS AND ANSWERS

EXCEL VBA MOST ASKED Job Interview Questions. Read EXCEL VBA Interview Questions and Answers for Experienced, Freshers PDF Download.

Read EXCEL VBA Questions and Answers for Interview

What is the difference between ByVal and ByRef and which is default?Answer
What is the meaning of Option Explicit and Option Base?Answer
What are various data type and their size?Answer
Difference between ActiveWorkbook and ThisWorkbook.Answer
Code to find a Last used Row in a column or Last used column of a Row.Answer
Difference between ActiveX and Form Controls.Answer
What is the difference b/w Functions and Subroutines?Answer
How to debug a VBA code?Answer
Draw basic Excel Object Model.Answer
What are properties, methods, events and objects?Answer
How to hide a worksheet so that a user cannot unhide it?Answer
Union is used for _____________ ?Answer
Which are the 2 macro languages and which do you use ?Answer
Can you lock cells such that only specific users can modify them?Answer
How can you add a drop-down list to a cell so the user can choose a value from the list?Answer
How can you increase the number of rows in a worksheet?Answer
How can you increase the number of columns in a worksheet?Answer
How will you distribute a workbook such that it can’t be copied using macro or anything?Answer
Your colleague created a dashboard and when you enter a value, it appears with two decimal places. For example, when you enter 265 it shows up as 2.65. What’s wrong?Answer
How can you prevent a user for adding or deleting sheets?Answer
What types of workbook protection are available?Answer
The Font dialog box allows you to select different Fonts, their style, their size, and some other special effects. How do you bring up this Font dialog box?Answer
What is ADO, OLEDB & ODBC?Answer
How to set the custom paper size in Excel Object through VB?Answer
What is the method for returning more than one values from a function in VB?Answer
Does VBA supports OOP principles?Answer
To set the command button for ESC, Which property needs to be changed?Answer
What is Type Library and its purpose?Answer
How do you use the Getsetting and Savesetting functions to read and write registry settings?Answer
What is a Variant, what the pros and cons of its use?Answer
Give technical reasons which made Microsoft withdraw its support for VBA in Mac?Answer
What is a volatile function?Answer
Give some examples of Volatile function.Answer
How do you make a UDF volatile?Answer
Is it possible to apply ‘Application.Volatile(False)’ to a volatile public function like INDEX and make it not volatile?Answer
What is Excel dependency tree?Answer
What are keyboard shortcuts and their equivalent VBA methods for Formulae calculation and building Excel dependency trees?Answer
What does Range.Dirty used for ?Answer
How do you check the Calculation state ?Answer
How do you define Excel Calculation Interruption Key to stop the calculation?Answer
What does ‘Workbook.ForceFullCalculation’ do?Answer
What are excel dependency tree limits?Answer
Mention those conditions when status bar shows CALCULATE.Answer
What do you know about multi threaded calculation?Answer
How can we dial a phone number?Answer
What do you know about the interpretation features of VBA?Answer
Explain about insert module and Goal Seek functions present in VBA?Answer
State the difference between Visual Basic, VB Script and Visual Basic for Applications?Answer
Write a macro to select all the non-blank cells of Activesheet?Answer
What is the difference between UsedRange and CurrentRegion properties?Answer