VBA (Visual Basic for Applications) Question:

What is line option explicit?

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.


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