How do I stop a Macro after "Cancel" is chosen in an input box?

**c991257** · 05-10-2007, 10:33 AM

I have the following code:

Please Login or Register  to view this content.

If I press cancel in the first Msg I can't stop the entire rutine. How do I do that?

/Møller

**mccreaso** · 05-10-2007, 10:41 AM

Hi, try:

Please Login or Register  to view this content.

HTH,

mccreaso

**mccreaso** · 05-10-2007, 10:43 AM

Originally Posted by mccreaso

Hi, try:

Please Login or Register  to view this content.

HTH,

mccreaso

Correction:

Please Login or Register  to view this content.

**stevebriz** · 05-10-2007, 10:51 AM

Another Example:

Please Login or Register  to view this content.

**c991257** · 05-10-2007, 02:09 PM

Perfect - it works, but why? Whats the difference?

/Møller

**stevebriz** · 05-10-2007, 02:27 PM

have a read of this:
This explains why.

http://support.microsoft.com/kb/142141