Return to Answer

• ! Single
• @ Currency
• # Double
• % Integer
• $ String
• & Long

• ! Single
• @ Currency
• # Double
• % Integer
• $ String
• & Long
• ^ LongLong (64 Bit Only)

Inputting to Subroutines via Cells

Inputting to Subroutines and Immediate Window Functions via Cells

Public Sub A(ByRef B as String)

Sub a(b$) 

s=[A1]

...
#If n=3 then
return ''  Produces error code '3', Return without GoSub
#ElseIf n=20 then
resume ''  Produces error code '20', Resume without Error
#EndIf
...

Public Function A(b)
    ...
    A=C
End Function

Debug.Print "Text"

Debug.?"Text"

Public Sub A(ByRef B as String)

Sub a(b$) 

s=[A1]

...
#If n=3 then
return ''  Produces error code '3', Return without GoSub
#ElseIf n=20 then
resume ''  Produces error code '20', Resume without Error
#EndIf
...

Public Function A(b)
    ...
    A=C
End Function

Debug.Print "Text"

Debug.?"Text"