VBA code: call subprocedure

[Terry]

Hi,
I am writing a VBA program。The program structure listed below：

Private Sub b(i As Integer, j As Integer)
......
End Sub

Sub a()
....
b (i, j)
...
End Sub

It appeard error message while I call subprocedure b in main-procedure a.
Error message :
Compile error
Miss :=

Would you tell me how to write the code in order to call the subprocedure b?
Thanks a lot!

[bpeltzer]

Put the word call in front of the procedure call: call b(i,j). Not entirely
sure why, but the help suggests: "a function call can't stand by itself, and
Sub procedure calls sometimes require the Call keyword, depending on how you
specify their arguments."


"Terry" wrote:

> Hi,
> I am writing a VBA program隆拢The program structure listed below拢潞
>
> Private Sub b(i As Integer, j As Integer)
> ......
> End Sub
>
> Sub a()
> ....
> b (i, j)
> ...
> End Sub
>
> It appeard error message while I call subprocedure b in main-procedure a.
> Error message :
> Compile error
> Miss :=
>
> Would you tell me how to write the code in order to call the subprocedure b?
> Thanks a lot!
>
>
>

[Leith Ross]

Hello Terry,

When calling a Sub procedure with parentheses like b(i, j), you must precede the cal with the keyword Call...

Call b(i,j)

Sincerely,
Leith Ross

[Leith Ross]

Hello Terry,

When calling a Sub procedure with parentheses like b(i, j), you must precede the cal with the keyword Call...

Call b(i,j)

Sincerely,
Leith Ross

[Terry]

Thank you very much!
"bpeltzer" <[email protected]> 写入消息新闻:[email protected]...
> Put the word call in front of the procedure call: call b(i,j). Not
> entirely
> sure why, but the help suggests: "a function call can't stand by itself,
> and
> Sub procedure calls sometimes require the Call keyword, depending on how
> you
> specify their arguments."
>
>
> "Terry" wrote:
>
>> Hi,
>> I am writing a VBA program?￡The program structure listed below￡o
>>
>> Private Sub b(i As Integer, j As Integer)
>> ......
>> End Sub
>>
>> Sub a()
>> ....
>> b (i, j)
>> ...
>> End Sub
>>
>> It appeard error message while I call subprocedure b in main-procedure a.
>> Error message :
>> Compile error
>> Miss :=
>>
>> Would you tell me how to write the code in order to call the subprocedure
>> b?
>> Thanks a lot!
>>
>>
>>

[Terry]

Thank you very much!
"Leith Ross" <[email protected]> 写入消息新闻:[email protected]...
>
> Hello Terry,
>
> When calling a Sub procedure with parentheses like b(i, j), you must
> precede the cal with the keyword Call...
>
> Call b(i,j)
>
> Sincerely,
> Leith Ross
>
>
> --
> Leith Ross
> ------------------------------------------------------------------------
> Leith Ross's Profile:
> http://www.excelforum.com/member.php...o&userid=18465
> View this thread: http://www.excelforum.com/showthread...hreadid=493258
>