A warning message on a macro

[zilch4ry]

Hi, I was just wondering if anybody knows if it is possible to place a warning message onto a macro before the macro runs, for example a warning such as "Have you made sure all information entered is correct?" then if the user selects 'Yes', the macro will run. any help on this will be greatly appreciated.

Thanks,





Tom

 

[asyamonique]

You can create additional userform which with two button yes/no then u can run the macro with yes or no back to normal.

 

[bertie]

Try something like this:

[COLOR=darkblue]Sub[/COLOR] test()
   [COLOR=darkblue]Dim[/COLOR] answer [COLOR=darkblue]As[/COLOR] [COLOR=darkblue]Long[/COLOR]
 
   answer = MsgBox("OK to Proceed?", vbYesNo)
 
   [COLOR=darkblue]If[/COLOR] answer = vbNo [COLOR=darkblue]Then[/COLOR]
     Exit [COLOR=darkblue]Sub[/COLOR]
   [COLOR=darkblue]End[/COLOR] [COLOR=darkblue]If[/COLOR]
 
[COLOR=green]  '[/COLOR]
[COLOR=green]  'code for answer = Yes goes here[/COLOR]
[COLOR=green]  '[/COLOR]
 
[COLOR=darkblue]End[/COLOR] [COLOR=darkblue]Sub[/COLOR]

 

[zilch4ry]

Thank you both for the answers, I have exactly what I wanted.
Tom