MZ tools Msgbox uses "Call"?
 

I'm new to MZTools, figuring out how and when to use it. Found some very
useful features - the "find" is great!

Have used the Msgbox help a couple of times, just to try it out. I'm
curious as to why it inserts a "Call" in front of Msgbox, like this:

Call MsgBox("There is no password listed for this sheet!", vbExclamation,
"Missing Password")

I've never used a "call" with a Msgbox, and it always worked fine. But if I
delete it here, the code goes red. Why?

As always, thanks!

MZ tools Msgbox uses "Call"?
 

Call is unnecessary, but if you omit it, you need to remove the parens
around the arguments.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"salgud" wrote in message
...
I'm new to MZTools, figuring out how and when to use it. Found some very
useful features - the "find" is great!

Have used the Msgbox help a couple of times, just to try it out. I'm
curious as to why it inserts a "Call" in front of Msgbox, like this:

Call MsgBox("There is no password listed for this sheet!", vbExclamation,
"Missing Password")

I've never used a "call" with a Msgbox, and it always worked fine. But if
I
delete it here, the code goes red. Why?

As always, thanks!

MZ tools Msgbox uses "Call"?
 

On Thu, 5 Mar 2009 08:36:40 -0500, Jon Peltier wrote:

Call is unnecessary, but if you omit it, you need to remove the parens
around the arguments.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"salgud" wrote in message
...
I'm new to MZTools, figuring out how and when to use it. Found some very
useful features - the "find" is great!

Have used the Msgbox help a couple of times, just to try it out. I'm
curious as to why it inserts a "Call" in front of Msgbox, like this:

Call MsgBox("There is no password listed for this sheet!", vbExclamation,
"Missing Password")

I've never used a "call" with a Msgbox, and it always worked fine. But if
I
delete it here, the code goes red. Why?

As always, thanks!

Thanks, John.