Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass multiple parameters through macros
I want to pass more than one parameter through a
procedure. Ex. Sub AAAAquery() Dim queryname Dim querynumber Dim testname Sub BBBBquery() AAAAquery (queryname) I can pass the defined variable queryname through. I want to add testname. Ex. Sub BBBBquery() AAAAquery (queryname, testname) This does not work. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass multiple parameters through macros
Hi
Sub Main() Call PassedToMe("Yo", 42, DateSerial(1944, 12, 5)) End Sub Sub PassedToMe(S As String, L As Long, D As Date) MsgBox "You said " & S & Chr(10) & _ "and the lucky number is " & L & Chr(10) & _ "and you were born " & D End Sub HTH. Best wishes Harald "Chris Perry" skrev i melding ... I want to pass more than one parameter through a procedure. Ex. Sub AAAAquery() Dim queryname Dim querynumber Dim testname Sub BBBBquery() AAAAquery (queryname) I can pass the defined variable queryname through. I want to add testname. Ex. Sub BBBBquery() AAAAquery (queryname, testname) This does not work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup by multiple parameters | Excel Worksheet Functions | |||
how to pass on different parameters to VBA Code? | Excel Worksheet Functions | |||
Can't get parameters on macros working... | Excel Programming | |||
Starting Excel from cmd pmpt, pass parameters | Excel Programming | |||
How to pass variable value between macros | Excel Programming |