CoolInterview.com - 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
COOLINTERVIEW.COM PROGRAMMING LANGUAGES INTERVIEW QUESTIONS VBA INTERVIEW QUESTIONS 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: CoolInterview.com
Question: What methods are called from the ObjectContext object to inform MTS that the transaction was successful or unsuccessful?



Answer: setabort and setcomplete Source: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
Question: How to register a component?




Answer: To register component use

run command prompt type:

c: regsvr32 nameofcomp
Source: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
Question: What does Option Explicit refer to?



Answer: Option Explicit makes the declaration of Variables Mandatory Source: CoolInterview.com
Question: What are the ADO objects? Explain them.



Answer: The ADO objects are:

? Command

? Connection

? Error
? Field

? Parameter

? Property
? Record

? RecordSet

? Stream

Source: CoolInterview.com
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: CoolInterview.com
Question: What was introduced to Visual Basic to allow the use of Callback Functions?



Answer: DTPicker Source: CoolInterview.com
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
Source: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
Question: To set the command button for ESC, Which property needs to be changed?



Answer: set cancel property to true

Ex: button1.cancel = true
Source: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
Question: Explain about visual basic and its importance?

Answer: Microsoft holds license for Visual basic applications and it has been developing that language. Visual basic applications have an embedded programming environment which assists programmers in developing custom solutions by using almost all features of visual basic. Applications which are currently hosting visual basic can fully utilize the power of Visual basic applications because they have an added functionality and ease of visual basic applications. Source: CoolInterview.com

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.328125 Seconds