Prevent macros running after message box show

**herukuncahyono** · 07-15-2013, 12:54 AM

I just got a code from stnkynts

Please Login or Register  to view this content.

And when I combine with my other code like:

Please Login or Register  to view this content.

Every time message box appears and click OK ... the value in the cell erased
if the many data is entered it will be hard to type it again

Is there any code to prevent the value in the cell is not deleted before editing

Thanks in advance

**HaHoBe** · 07-15-2013, 01:00 AM

Hi, herukuncahyono,

tell VBA to exit the sub?

Please Login or Register  to view this content.

Ciao,
Holger

**herukuncahyono** · 07-15-2013, 01:09 AM

hi Holger

Wow.. its work...

Thank you so much..

for stnkynts thank you too

Re: Prevent macros running after message box show