Programming with VBA MCQ with Answers

Programming with VBA MCQ with Answers

86) Which scope does the variable declared with dim and remains in the existence only as long as the procedure in which if is declared is running?

Answer is:

Local scope

87) What will be the output of the following VBA code?
Sub test()
a = 9
Debug.Print Sqr(a)
End sub

Answer is:

3

88) What will be the output for the following VBA code?Debug.print
DateDiff('yyyy','1/12/2016','31/1/2017')

Answer is:

1

89) What will be the output of the following VBA code?
Sub test()
x = 'institue'
Debug.print Format(x,'>')
End sub

Answer is:

INSTITUTE

90) What will be the output of the following VBA code?
Sub test()
Dim S AS string
S = 'wholehearted'
Debug.Print mid(s,6,4)
End sub

Answer is:

hear