- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
VBA Interview Questions & Answers - Learning Mode

VBA Interview Questions & Answers - 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).

Try VBA Interview Questions & Answers - Exam Mode

1 2 Next

Sort By : Latest First | Oldest First | By Rating

VBA Interview Questions & Answers - Learning Mode
Try VBA Interview Questions & Answers - Exam Mode
Question: Which controls have refresh method, clear method

Answer: Datagrid,listbox,combobox,label,button have refresh methodand textbox has clear methodalmost all controls have refresh method Source:
Question: What methods are called from the ObjectContext object to inform MTS that the transaction was successful or unsuccessful?

Answer: setabort and setcomplete Source:
Question: How can you format expressions by using VBA?

Answer: Format functions can be used to format many of the expressions such as currency, time, date, percentages and numbers. These functions are much simpler to use in VBA. User defined date, numeric and string formats are present in many of the applications. Source:
Question: How to register a component?

Answer: To register component use

run command prompt type:

c: regsvr32 nameofcomp
Question: Explain about the security vulnerabilities for VBA?

Answer: Microsoft Visual basic has its host of problems one such being macros, Macros can be created which can create a havoc for a programmer with good intentions. Also the security issue rests in the hands of the user and not the programmer as such. A user can manipulate the VBA document. Source:
Question: Explain about line option explicit?

Answer: Line explicit function makes the compiler to identify all the variables which are not specified by the dim statement. This command significantly reduces the problem of type errors. This is used extensively because VBA deals with information rich applications in which type errors are common. Source:
Question: How can we use data validation function in VBA?

Answer: Data validation is an important concept in VBA. Application procedure and a custom dialog box can be used to correct input errors. You can assign an application procedure to the frame of a dialog box. Error message or custom dialog box can be highlighted with the first field with errors. Source:
Question: What is the difference between Msgbox Statement and MsgboxQ function?

Answer: MsgBox is a built in VB function which displays a Message Box and MsgBoxQ is a function defined by the user. Source:
Question: What are the ADO objects? Explain them.

Answer: The ADO objects are:

? Command

? Connection

? Error
? Field

? Parameter

? Property
? Record

? RecordSet

? Stream

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

Answer: No compatibility - creates new GUIDproject compatibility binary compatibility - maintains the references Source:
Question: How do you use the Getsetting and Savesetting functions to read and write registry settings?

Answer: A computer registry can be used to store configuration settings and application initialization. We can use Getsetting function to read registry settings and save settings function to write registry settings. Application name, section, key, setting, and default are to be specified for registry modifying. It is advisable to know about your computer settings before modifying registry settings. Source:
Question: What was introduced to Visual Basic to allow the use of Callback Functions?

Answer: DTPicker Source:
Question: Constructors and distructors

Answer: 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. Source:
Question: What does Option Explicit refer to?

Answer: Option Explicit makes the declaration of Variables Mandatory Source:
Question: 3 main differences between flexgrid control and dbgrid control

Answer: 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
Question: Explain about insert module and Goal Seek functions present in VBA?

Answer: The chief use of VBA is to make use of its special function which helps in repeated actions. Goal seek function helps to reduce manual entry of the code each and every time. This solves the problem of repeated function entry by automating functions and actions. Sub routines are inserted into the using the VBA editor and command insert module. Source:
Question: Explain about function pointers?

Answer: Visual basic applications have very rich and flexible applications but there is one limitation when using pointer function. Windows API has limited support for function pointers because it has the ability to use but not the functional support to call back the function. But later versions have support for modules. Function pointers have inbuilt support (DLL`s) for call but not for call back. Source:
Question: To set the command button for ESC, Which property needs to be changed?

Answer: set cancel property to true

Ex: button1.cancel = true
Question: Which property of menu cannot be set at run time?

Answer: Name property cannot set at run time

Question: State about the interpretation features of VBA?

Answer: VBA is licensed to Microsoft and this compatible with and only Microsoft products. Code written is compiled by an intermediate language called P-code and this is stored in hosting applications such as Excel, Word and Access. The intermediate code is interpreted by a virtual machine. This code and intermediate language is the exclusive right of Microsoft. Source:

1 2 Next

India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.03125 Seconds