Advanced EXCEL Interview Questions - Avatto

Name some of the Excel formats which an Excel file can be saved?

.XLS .XLSX .XLSM (Macro-enabled workbook) .XLSB (Binary format) .CSV (Comma Separated Values)

How will you pass arguments to VBA Function?

In 2 ways we can pass arguments to VBA
Functions
ByVal
ByRef

What are the modules available in VBE?

Code Module: Default module to write procedures.
User form: Helps to develop GUI (Graphical User Interface) applications.
Class Module: Allows to create new objects.

What is Collection in VBA?

The Collection object contains a set of related groups of items as a single object.

What is the difference between an Array and Collection?

Collections and Arrays are used to group variables. In Arrays, before using to start adding elements we normally set the size. But in Collection, we will not set the size, because we don’t know the number of elements in advance.