I spent 11+ years of my career in various version of Excel and VBA. I used to hear from lot of people (even VPs & top leaders) that Excel is going to get outdated. Funny part is, I've been listening the same words again and again past 10 years, but nothing happened.
Excel is still a primary tool for data analysis and reporting and we cannot avoid VBA when you talk about Excel. I see that it will still have an important role for at least next 10 years as we don't have an alternative available which provides simple way to get complex things done.
I would like to share some Excel VBA Macros Interview Questions & Answers, which I had used to conduct technical interviews behalf of my clients to hire candidates for them.
The Questions has been prepared keeping in mind to evaluate the candidate's depth of knowledge in Excel VBA. 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 are a beginner in Excel VBA, I would not suggest this for you. Because in most of the cases the interviewer will not stop asking questions by giving a one line answer. He may ask you to describe more about the facts of the topic he asked to understand how good you are in the tools.
Kindly share the feedback in comments or contact me directly macromatician[at]gmail.com
I will be updating more when I have time. Click on the below links to go to each pages.
Basic Excel VBA Macros Interview Questions
1. Basic Excel VBA Macros Interview Questions - Set 1 - January 2018 - 10 Questions
2. Basic Excel VBA Macros Interview Questions - Set 2 - February 2018 - 10 Questions
Advanced Excel VBA Macros Interview Questions:
1. Excel VBA Macros Interview Questions Part I - 10 Questions
2. Excel VBA Macros Interview Questions Part II - 10 Questions