![]() What is the meaning of Option Explicit and Option Base? Solution: Option Explicit makes the declaration of Variables Mandatory while Option Base used at module level to declare the default lower bound for array subscripts. If you do not explicitly specify to pass an argument by value VBA will pass it by reference. ByRef is default: Passing by reference is the default in VBA. ByVal: If you pass an argument by value when calling a procedure the variable's value can be changed with in the procedure only outside the actual value of the variable is retained. As a result, the variable's value can be changed by the procedure. Solution: ByRef: If you pass an argument by reference when calling a procedure the procedure access to the actual variable in memory. What is the difference between ByVal and ByRef and which is the default? 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' ![]() ![]() If you're looking for a job in MIS/Automation/Dashboard creation etc. 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. 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.
0 Comments
Leave a Reply. |