VBA (Visual Basic for Applications) Question:

Download Job Interview Questions and Answers PDF

What is line option explicit?

VBA Interview Question
VBA Interview Question

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.

Download VBA Interview Questions And Answers PDF

Previous QuestionNext Question
What is pointers function?How to use data validation function in VBA?