Connecting Tech Pros Worldwide Help | Site Map

Subroutines multiple arguments

  #1  
Old November 21st, 2008, 03:25 PM
jim
Guest
 
Posts: n/a
Hi,

This might be a dumb question but i'm trying to pass a couple of
arguments to a subroutine and keep getting an error message

This:

Sub showNumbers(a As Integer)
MsgBox (a & ", " & a)

End Sub


Private Sub Command0_Click()
showNumbers (1)

End Sub

Works Fine!




But This:

Sub showNumbers(a As Integer, b As Integer)
MsgBox (a & ", " & b)

End Sub

Private Sub Command0_Click()
showNumbers (1, 2)

End Sub

gives a syntax error..

Any help much appreciated..

thanks

jim

  #2  
Old November 21st, 2008, 03:25 PM
paii, Ron
Guest
 
Posts: n/a

re: Subroutines multiple arguments


Try calling like this

showNumbers 1,2


"jim" <jim@j.comwrote in message
news:crCdnYXkn-OkTLvUnZ2dnUVZ8jOdnZ2d@posted.metronet...
Quote:
Hi,
>
This might be a dumb question but i'm trying to pass a couple of
arguments to a subroutine and keep getting an error message
>
This:
>
Sub showNumbers(a As Integer)
MsgBox (a & ", " & a)
>
End Sub
>
>
Private Sub Command0_Click()
showNumbers (1)
>
End Sub
>
Works Fine!
>
>
>
>
But This:
>
Sub showNumbers(a As Integer, b As Integer)
MsgBox (a & ", " & b)
>
End Sub
>
Private Sub Command0_Click()
showNumbers (1, 2)
>
End Sub
>
gives a syntax error..
>
Any help much appreciated..
>
thanks
>
jim
>

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
pass part of name as argument tshad answers 10 January 18th, 2007 12:15 AM
Trigraphs & entry Vijay Kumar R Zanvar answers 14 November 13th, 2005 10:14 PM
Passing arguments to function by reference - Good or Bad? Mike MacSween answers 39 November 13th, 2005 11:55 AM
Error Trapping In Access 2000 Peter Frost answers 6 November 12th, 2005 10:50 PM