Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct Syntax for Calling other Subs
Hi All,
What do I need to change in order to get the following to work. Should I be using a function for this sort of routine? I get the error "expected function or variable" Sub TestSub(var1 As Integer) TestSub = var1 + 2 End Sub Sub testsub2() Dim var1 var1 = TestSub(2) MsgBox var1 End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct Syntax for Calling other Subs
When your code returns a value it needs to be a Function, not a Sub:
Function TestSub(var1 As Integer) as Integer TestSub = var1 + 2 End Function Sub testsub2() Dim var1 var1 = TestSub(2) MsgBox var1 End Sub "Andibevan" wrote: Hi All, What do I need to change in order to get the following to work. Should I be using a function for this sort of routine? I get the error "expected function or variable" Sub TestSub(var1 As Integer) TestSub = var1 + 2 End Sub Sub testsub2() Dim var1 var1 = TestSub(2) MsgBox var1 End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Correct Syntax for Calling other Subs
Thanks - didn't realise that
"K Dales" wrote in message ... When your code returns a value it needs to be a Function, not a Sub: Function TestSub(var1 As Integer) as Integer TestSub = var1 + 2 End Function Sub testsub2() Dim var1 var1 = TestSub(2) MsgBox var1 End Sub "Andibevan" wrote: Hi All, What do I need to change in order to get the following to work. Should I be using a function for this sort of routine? I get the error "expected function or variable" Sub TestSub(var1 As Integer) TestSub = var1 + 2 End Sub Sub testsub2() Dim var1 var1 = TestSub(2) MsgBox var1 End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling subs from different workbooks | Excel Programming | |||
Calling VBA add-in functions/subs from another Excel file. | Excel Programming | |||
calling subs | Excel Programming | |||
calling subs, Doesn't seem to run fisrt time? | Excel Programming | |||
calling private subs | Excel Programming |