VBA interview questions

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

To set the command button for ESC, Which property needs to be changed?

What is the difference between Msgbox Statement and MsgboxQ function?

Name the four different cursor and locking types in ADO and describe them briefly

What are the ADO objects? Explain them.

Type Library and what is its purpose?

Which property of menu cannot be set at run time?

VB and Object Oriented Programming

What is differece b/w Module and class Modules in vb6?thanks

Which Property is used to compress a image in image control?

How to register a component?

Advantage of ActiveX Dll over Active Exe

Which controls have refresh method?

What does Option Explicit refer to?

Benefit of wrapping database calls into MTS transactions

What are the different compatibility types when we create a COM component?

3 main differences between flexgrid control and dbgrid control

Which property of textbox cannot be changed atruntime and what?s the maximum size of a textbox?

Which controls have refresh method, clear method

Constructors and distructors

What was introduced to Visual Basic to allow the use of Callback Functions?

Name of the control used to call a windows application

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?

Which controls can not be placed in MDI?

In VB which control does not have event?

How to create Crystal Report in Visual Basic 6.0

Name the four different cursors and locking types in ADO and describe them briefly?

How would you convince a big brand of chocolate to sell a middle range of chocolate products?

WHAT IS DATA ANALYSIS?