Properly Using a Sub Procedure in Microsoft Office Excel - Visual Basic for Applications

Option Explicit
Sub callMacros()

MacroInteger 7

MacroString "a String"

MacroIntegerString 4, "some string"

End Sub




Sub MacroInteger(I As Integer)

MsgBox "Integer i=" & I

End Sub



Sub MacroString(S As String)

MsgBox "String value=" & S

End Sub



Sub MacroIntegerString(I As Integer, S As String)

MsgBox "I=" & I & ", S=" & S

End Sub