Below we have listed all the VBA Interview Questions and answers. Feel free to comment on any VBA Interview Questions or answer by the comment feature available on the page.
To buy an eBook containing 30,000 Interview Questions, with Answers, Click Here.
View All VBA Interview Questions & Answers - Exam Mode /
Learning Mode
VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs. Create a Macro: With Excel VBA you can automate tasks in Excel by writing so called macros. Visual Basic for Applications (VBA) is an implementation of Microsoft's discontinued event-driven programming language, Visual Basic 6, and its associated integrated development environment (IDE).
| Highly Recommended, Hand Picked VBA Books | |||
|
|
|||
 
|
 
|
 
|
 
|
|
|
|||
 |
Which controls have refresh method, clear method |
|
|
|
Advantage of ActiveX Dll over Active Exe |
|
|
|
Explain about the security vulnerabilities for VBA? |
|
|
|
Which controls can not be placed in MDI? |
|
|
|
What are the different compatibility types when we create a COM component? |
|
|
|
What do ByVal and ByRef mean and which is the default? |
|
|
|
What methods are called from the ObjectContext object to inform MTS that the transaction was successful or unsuccessful? |
|
|
|
What is the difference between Msgbox Statement and MsgboxQ function? |
|
|
|
State about the interpretation features of VBA? |
|
|
|
Which Property is used to compress a image in image control? |
|
|
|
Which property of textbox cannot be changed at runtime and what?s the maximum size of a textbox? |
|
|
|
What does Option Explicit refer to? |
|
|
|
Explain about visual basic and its importance? |
|
|
|
I would like to do the following. If cell A1 contains "Hello" and if the focus is on A1 and if the Enter key is pressed, then the focus should go to B2 and a MsgBox should appear. I think this can be done with key events, something like OnKeyDown, but how do I tell it I want the event only be triggered by the Enter key? |
|
|
|
Define and explain about COM add-ins? |
|
|
|
To set the command button for ESC, Which property needs to be changed? |
|
|
|
State some general uses for Visual basic applications in general context? |
|
|
|
3 main differences between flexgrid control and dbgrid control |
|
|
|
Explain about function pointers? |
|
|
|
Explain about line option explicit? |
|
India News Network |
