View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mike_vr mike_vr is offline
external usenet poster
 
Posts: 42
Default Simple Yes / No messagebox followed by an if then else formula

Hi there

Created a macro that clears a spreadsheet, and have put in a button that
runs it once clicked. Now all I want is a simple yes/no/cancel option to come
up that, once the button is clicked, the user can still cancel before the
macro runs, unless he is happy to go with it in which case all the data will
be cleared.
Pretty simple I'm sure, but I have no idea how to launch the messagebox, and
then based on the yes / no click to run the macro or not?!?

Any thoughts?

Thanks,
mike