Here is a list of VBA Interview Questions that you must prepare for all VBA interviews for freshers and experienced in real time. Also go through Windows General Interview Questions
VBA Interview Questions
What are various data types and their size?
What is the difference between ByVal and ByRef in VBA?
What is the difference between ActiveWorkbook and ThisWorkbook?
How will you find the last used row or column in a range?
What is the difference between Functions and Subroutines?
How to debug VBA code ?
How to add a dropdown list to a cell in excel in VBA?
What is the difference between UsedRange and CurrentRegion properties ?
What is the meaning of Option Explicit and Option Base?
How to declare variable and constant in VBA?
Explain ODBC, ADO and OLEDB ?
Explain how can you dial a phone number through VBA?
How can you stop VBA script when it goes into the infinite loop?
How can you comment and uncomment blocks of code in the office VBA editor?
Useful Links – Microsoft Excel VBA Tutorials Online