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 |
|
|
|
Which controls can not be placed in MDI? |
|
|
|
Explain about the security vulnerabilities for VBA? | 
|
|
|
What do ByVal and ByRef mean and which is the default? |
|
|
|
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? |
|
|
|
State about the interpretation features of VBA? |
|
|
|
What are the different compatibility types when we create a COM component? |
|
|
|
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? |
|
|
|
State some general uses for Visual basic applications in general context? |
|
|
|
Explain about visual basic and its importance? |
|
|
|
What methods are called from the ObjectContext object to inform MTS that the transaction was successful or unsuccessful? |
|
|
|
What does Option Explicit refer to? |
|
|
|
What is the difference between Msgbox Statement and MsgboxQ function? |
|
|
|
To set the command button for ESC, Which property needs to be changed? |
|
|
|
3 main differences between flexgrid control and dbgrid control |
|
|
|
Explain about function pointers? |
|
|
|
What forms should be used for Complex user Input? | 
|
India News Network |
