www.ThinkITI.com

Home
MCQ
Search
Free Apps
Important
Study Groups
Contact Us
Policy

Home
MCQ
Objective Questions
ITI
COPA
COPA Set-1
Programming with VBA
5

Programming with VBA MCQ with Answers

5) Which variable recognized only within the procedure in which it is declared?

Local scope

Module scope

Global scope

Project scope

Answer is:

Local scope

Programming with VBA MCQ with Answers

For more MCQ's Click Here

Related Programming with VBA MCQ with Answers

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

2

3

4

7

Answer is:

4

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

1/1/2017

Sun, Jan01, 2017

2017/01/01

Sunday, January 01, 2017

Answer is:

2017/01/01

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

CDate()

IsDate()

Day()

Dateadd()

Answer is:

IsDate()

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

User Data Functions

User Defined Functions

Undefined Functions

Used Data Functions

Answer is:

User Defined Functions

Programming with VBA MCQ with Answers

For more MCQ's Click Here