Programming with VBA MCQ with Answers

Programming with VBA MCQ with Answers

6) How many levels of variable scope available in VBA?

Answer is:

4

7) What will be the output of the following VBA code?
Debug.printformat(#1/1/2017#,'yyyy/mm/dd')

Answer is:

2017/01/01

8) Which function returns true if the expression is a valid date, otherwise it returns false in VBA?

Answer is:

IsDate()

9) What is the full form of UDF in VBA?

Answer is:

User Defined Functions

10) Which function returns the day of the month (number from 1 to 31) given date value in VBA?

Answer is:

Day()