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
|