What's the point of the Call statement?

AJ · Apr 19th, 2002, 04:34 AM

Quick query: Why bother with the Call Statement?

If you want to run one macro from within another one I've seen code like:

Sub test()
'Do something, then
Call test2
End Sub

or just

Sub test()
'Do something, then
test2
End Sub

Why the Call statement. Does it add anything, or am I missing something?

Rgds
AJ

Ivan F Moala · Apr 19th, 2002, 05:40 AM

It's just syntax left over for backward
compatibility with older versions of BASIC.
You don't need it at all.

Mudface · Apr 19th, 2002, 05:44 AM

You do need it if you're passing arguments to a procedure though, don't you, Ivan?

Mudface · Apr 19th, 2002, 05:50 AM

Actually, ignore that, it's only if you use brackets around your arguements, sorry.

Apr 19th, 2002, 05:40 AM	#2
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	It's just syntax left over for backward compatibility with older versions of BASIC. You don't need it at all. __________________ Kind Regards, Ivan F Moala From the City of Sails

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 04:34 AM	#1
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	Quick query: Why bother with the Call Statement? If you want to run one macro from within another one I've seen code like: Sub test() 'Do something, then Call test2 End Sub or just Sub test() 'Do something, then test2 End Sub Why the Call statement. Does it add anything, or am I missing something? Rgds AJ

Apr 19th, 2002, 05:44 AM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	You do need it if you're passing arguments to a procedure though, don't you, Ivan?

Apr 19th, 2002, 05:50 AM	#4
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Actually, ignore that, it's only if you use brackets around your arguements, sorry.