Please enter your details here.
To load graphics on a control at runtime, we have to use the function….
Do…Loop... Until code block is always executed once.
A ____________ is a predefined VB procedure that you can call upon when needed.
Which is the conversion for the following If...Then...ElseIf statement to a Select...Case statement?
If intValue > 0 And intValue <= 9 Then
discount = .10
Else If intValue >9 And intValue <=20
discount = .15
Else
discount = .20
What is the color of comments?
The _______________ control used to insert image to the form
When the form is first referenced in any manner by program,the triggered event is….
Which of the following is default in VBA for data passing?
What property of controls tells the order they receive the focus when the tab key is pressed during run time? it.
__________ are the attributes of an object that control the object's appearance and behavior.
The value returned by InputBox is a string
___________ statement enables us to trap runtime error.
VBA Code run by
Which of the following statement is not a looping statement in VBA?
Suppose you need to develop an online poll of user responses to a question. For convenience, you would like the most popular options to be displayed in a list for the user to quickly select an option and submit their answer. However, you would also like them to be able to use the same control to allow them to specify an write-in value of their own. Which control is most appropriate for this application?
Which of the following arithmetic operations has the highest level of precedence?
Which character in VBA, indicates start of a comment
This operator reverses the truth value of an expression; making a true expression false and a false expression true.
What do you need to select to set the developer mode?
Which Case clause will be true whenever the value of the selector in a Select Case block is between 1 and 5 or is 8?
32-bit Software/Applications can be installed on:
Private Procedure can be called from anywhere in the project
Which property for a textbox allows the textbox to accept more than 1 line of data entry?
Suppose the variable myName is declared in a Dim statement in two different Sub procedures. Which statement is true?
___________ function is used to return a copy of a string without leading spaces.
___________ indicates whether a particular condition is on or off
Which property determines whether a control is displayed to the user?
Basic Excel Object model as follows:
When the block of code finishes the execution, what will the final value of X be?
Public Sub Example ()
Dim Y As Integer
Dim X As Integer
X = 0
Y = 10
For Count = Y To 1 Step -2
X = X + Y
If Y = (Y = 1) Then
Exit For
End If
Next Count
X = X / X
MsgBox X
End Sub
A ______________ returns a value to the part of the program that called it.