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!

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!

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.