VBA Interview Questions

Tab index is associated with tab button, i.e. when we press tab then it moves to next element
snd list index is associated with List box controls items present in List Box

Early Binding: Manually binding the OLB file is called early binding. Its "early" because you are exposing the object model during design-time, as opposed to during run-time. Sub CheckBinding() ...

Caption

Code
buton1.caption="XYZ"

Name Property in Properties window

if Sr1="true" and sr2="true" then
reporter.reportevent micpass ,'tc1','Verify the check functionality'
else
reporter.reportevent micfail ,'tc2','verify the check functionality,
endif

1. Datagrid is Editable, flexgrid is Diplay only.

2. DBGrid allows full data binding while MSFlexGrid allows read-only binding

3.  MSFlex grid is smaller and allows cell merging while Datagrid is larger and does not allow cell merging.

3 main differences between flexgrid control and dbgrid control

COM means Component Object Model it is a windows default object which has got lib files in the sys dir.
As for VB we need to add in .dll files to update COM files.

The property of textbox which we cannot change at run time are:
name
multiline.

Hi All,

 We can not change the 'Multiline' proprty of TextBox at the Run Time.

  and TextBox has No Limits

Use Application.Dialogs(xlDialogFont).Show to load fond dialog box from Excel VBA

In such a case, I would prefer to create a class with the properties I require to return, and then return the object of the class from the function.

Thanks,
Vikas

2 methods, use ByRef for the variables or return an array of values

ACTIVEX: ActiveX  are reusable software components or simply a class by which we can call a member functions or datamembers on creating object or simply drag & drop a control to access its functionality.

3 Types:
ActiveX dll
ActiveX exe
ActiveX control

Constructors have same name as class has, constructor's need not any call through objects, they are called automatically when an instance of class is created.
Destructors are used to make the memory free used by constructor variable, it do it's job just defining a destructor at the end of pro. 

when we initialize the form at that time if we want to set any variable's value then we can set it by defining in constructor. constructor 's name always same as class name.and destructor is used to recover memory occupied by any variable defining in constructor.

This enables MTS to reuse database connections.  Database connections are sent to "sleep" mode as against normal constructions and destructions.  This can be revoked upon request.

Trap Enter with ASC code 13 not 32 (which is ASCII code of space)

Use KeyAscii and trap enter(32).

 Shape and Line Controls

Line Control

 By setting the UseMnemonic property to true

  Connect Property

object pooling....

ODBC : Open Database Connectivity(ODBC) is a windows technology that lets a database client application connect to a external database.OLEDB : Low level programming interface designed ...

In the bad old days (before Win95), Windows could only do one thing at a time. This meant that events like mouse clicks and other user input could only be serviced in order, like everything else, even...