Question

What is the use of Dim statement? Explain with example.

Answer 1

Answer:

The Dim keyword is short for Dimension. It is used to declare variables in VBA. Declare means we are telling VBA about a variable we will use later. There are four types of Dim statements. They are all pretty similar in terms of syntax.

Explanation:

Dim [ WithEvents ] varname [ ( [ subscripts ] ) ] [ As [ New ] type ] [ , [ WithEvents ] varname [ ( [ subscripts ] ) ] [ As [ New ] type ]] . . .