help with input box - yes/no

[avishain]

hello there,

i got some useres who work with excel 2007.

i created a macro that save a file to a spesific folder and i need help with the followin:

i want a macro that once the user hits on it - it will pop up a msg/input box and will as the user :

"are you sure you want to save the file"?

i want that the user will choose between 2 options:

"yes" - the macro will proceed to the macro that i created
"cancel" -the macro will exit.

by the way,i do i create these 2 buttons? ( i dont want that the user will have to type the answer-i want him to click with the mouse )
thanks

 

[VoG]

Try like this

If MsgBox("Are you sure that you want to save", vbYesNo + vbQuestion) = vbNo Then Exit Sub
'
'rest of your macro

 

[wigi]

Would you also be happy with 3 buttons: Yes / No / Cancel?

 

[avishain]

Try like this

If MsgBox("Are you sure that you want to save", vbYesNo + vbQuestion) = vbNo Then Exit Sub
'
'rest of your macro

thank you very much