Thread: Message Box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jordan Jordan is offline
external usenet poster
 
Posts: 144
Default Message Box

I have a macro that clears cells. I would like to ask the user if they are
sure they want to complete the macro before it runs. Can any one tell me how
to get the message box to appear with a yes or no button and also if they say
no how to stop the macro from running.

I only know how to write macro by recording them so the more information you
can give me will be greatly appreciated.

Thanks.