50 Excel VBA Oral Interview Questions

These Excel VBA Interview questions are being posted keeping in mind that reader is aware of working with VBA, have some programming and MS Excel background and is aware of terminologies. This question bank is helpful for both Interviewee and Interviewer as it provides a quick channel of questions and answers covering major topics of Excel and VBA.

If you're looking for a job in MIS/Automation/Dashboard creation etc. as a Business Analyst, Senior Analyst, Associate Analyst, etc involving MS Excel, MS Access, VBA, SQL, Cognos, ASP.NET etc then Click here on 'Excel VBA Job Postings'

Ques 01. What is the difference between ByVal and ByRef and which is the default?
Solution: ByRef:
If you pass an argument by reference when calling a procedure the procedure access to the actual variable in memory. As a result, the variable's value can be changed by the procedure.
ByVal: If you pass an argument by value when calling a procedure the variable's value can be changed with in t…

Difference between ByVal and ByRef in VBA

Change Capital Letters to Small (Upper, lower, Proper Case conversion using Excel/VBA)

15 Excel Pivot Table Interview Questions with Answers

Remove Color of all Sheet's tabs in Microsoft Excel

Close all Saved Workbooks in Excel Application

Delete 'n' characters from a range of cells in MS Excel

MS Excel Formulas: CHAR/CODE - Text Functions

How to use MS Excel Macro Recorder ?

MS Excel & VBA: Contact for Corporate Trainings

We need Work ! We want to help you ! Let's Connect :)

15 Essential MS Excel VBA Puzzles for Interview

Relative and Absolute References in Excel Formulas

Online MS Excel Training: Quicker Excel

Split the Text with Newline Characters (Alt + Enter)

Monthly Calendar Planner Template

Sort TCP/IP Address or Delimited Numbers

Load Array from Sheet Range

Analyzing Date and Time Related Data in Excel

Create Excel Dashboard using OFFSET, SUM and MATCH functions

ADD ERROR TRAP: Wrap your Formulas with IFERROR or ISERROR