VBA "Compile error: Argument not optional" debugging sub

Question

I am trying to debug this simple section of code:

Public Sub FunctionNotValidVarType()
MsgBox "VarType " & VarType & " is not supported. Please check spelling."
End Sub

Answer 1

Public Sub FunctionNotValidVarType()
Dim variable As Integer
variable = 2
MsgBox "VarType " & VarType(variable) & " is not supported. Please check spelling."
End Sub

You need to call the VarType function passing to it an actual variable