IDC Technologies MIS Analyst Interview Questions and Answers

To start VBA code, create a new module and define a sub procedure.

• Open Microsoft Excel and press ALT + F11 to open the Visual Basic Editor

• In the Project Explorer, right-click on the workbook and select Insert > Module

• Define a sub procedure by typing 'Sub' followed by the name of the procedure

• Add the code inside the sub procedure

• Save the module and close the Visual Basic Editor

Option Explicit is a statement used in VBA to force variable declaration while Option Base is used to set the lower bound of an array.

• Option Explicit is used to avoid undeclared variables in VBA code

• Option Base is used to set the lower bound of an array in VBA

• Option Explicit is recommended to be used in all VBA code

• Option Base is optional and defaults to 0 if not specified

• Example: Option Explicit Dim x As Integer x = 5...read more