Visual Basic for Applications (VBA) Interview Questions

 
1.
Explain What are the ADO objects?
2.
Explain the difference between Msgbox Statement and MsgboxQ function?
3.
Explain Which controls can not be placed in MDI?
4.
Explain the difference between visual basic, VB script and visual basic applications?
5.
How to format expressions by using VBA?
6.
What is insert module and Goal Seek functions present in VBA?
7.
Explain four different cursor and locking types in ADO and describe them briefly?
8.
Explain Which controls have refresh method, clear method?
9.
What is pointers function?
10.
What is line option explicit?
11.
How to use data validation function in VBA?
12.
Explain What does Option Explicit refer to?
13.
Explain Which Property is used to compress a image in image control?
14.
Explain What do ByVal and ByRef mean and which is the default?
15.
Explain Which property of textbox cannot be changed at
runtime and what?s the maximum size of a textbox?
16.
Explain Type Library and what is its purpose?
17.
Explain Benefit of wrapping database calls into MTS transactions?
18.
Explain Advantage of ActiveX Dll over Active Exe?
19.
Explain technical reasons which made Microsoft withdraw its support for VBA in Mac?
20.
Explain about COM add-ins?
21.
Explain How to register a component?
22.
Explain VB and Object Oriented Programming?
23.
Explain some general uses for Visual basic applications in general context?
24.
Explain What are the different compatibility types when we create a COM component?
25.
How to dial a phone number?
26.
Explain Which property of menu cannot be set at run time?
27.
Explain What was introduced to Visual Basic to allow the use of Callback Functions?
28.
How to use the Getsetting and Savesetting functions to read and write registry settings?
29.
Explain the interpretation features of VBA?
30.
What is visual basic and its importance?
31.
What is Constructors and distructors?
32.
Explain 3 main differences between flexgrid control and dbgrid control?
33.
What is the security vulnerabilities for VBA?
34.
Explain What forms should be used for Complex user Input?
35.
Explain What methods are called from the ObjectContext object to inform MTS that the transaction was successful or unsuccessful?
36.
Name the platforms through which visual basic applications are available?
37.
How To set the command button for ESC, Which property needs to be changed?
38.
Name of some control used to call a windows application?
39.
Explain What are the ADO objects?
40.
Explain the difference between Msgbox Statement and MsgboxQ function?
41.
Explain Which controls can not be placed in MDI?
42.
Explain the difference between visual basic, VB script and visual basic applications?
43.
How to format expressions by using VBA?
44.
What is insert module and Goal Seek functions present in VBA?
45.
Explain four different cursor and locking types in ADO and describe them briefly?
46.
Explain Which controls have refresh method, clear method?
47.
What is pointers function?
48.
What is line option explicit?
49.
How to use data validation function in VBA?
50.
Explain What does Option Explicit refer to?
51.
Explain Which Property is used to compress a image in image control?
52.
Explain What do ByVal and ByRef mean and which is the default?
53.
Explain Which property of textbox cannot be changed at
runtime and what?s the maximum size of a textbox?
54.
Explain Type Library and what is its purpose?
55.
Explain Benefit of wrapping database calls into MTS transactions?
56.
Explain Advantage of ActiveX Dll over Active Exe?
57.
Explain technical reasons which made Microsoft withdraw its support for VBA in Mac?
58.
Explain about COM add-ins?
59.
Explain How to register a component?
60.
Explain VB and Object Oriented Programming?
61.
Explain some general uses for Visual basic applications in general context?
62.
Explain What are the different compatibility types when we create a COM component?
63.
How to dial a phone number?
64.
Explain Which property of menu cannot be set at run time?
65.
Explain What was introduced to Visual Basic to allow the use of Callback Functions?
66.
How to use the Getsetting and Savesetting functions to read and write registry settings?
67.
Explain the interpretation features of VBA?
68.
What is visual basic and its importance?
69.
What is Constructors and distructors?
70.
Explain 3 main differences between flexgrid control and dbgrid control?
71.
What is the security vulnerabilities for VBA?
72.
Explain What forms should be used for Complex user Input?
73.
Explain What methods are called from the ObjectContext object to inform MTS that the transaction was successful or unsuccessful?
74.
Name the platforms through which visual basic applications are available?
75.
How To set the command button for ESC, Which property needs to be changed?
76.
Name of some control used to call a windows application?