What is the syntax to declare variables?

'to declare procedure variables
Dim <variable name> As <variable type>

‘to declare procedure variables that retains value
Static <variable name> As <variable type>

‘module variable
Private <variable name> As <variable type> 

‘global variable
Public <variable name> As <variable type> 

 

Advertisements