Msgbox vba help!!

[Excelnoobisme]

Is it possible if i was to close a worksheet, it will show me a reminder msgbox or form to ask me certain thing.Then i.e. if 'Yes' close the worksheet, if 'No' then dont close the worksheet

 

[Excelnoobisme]

i have created form, but the hard part for me now is to let the userform appear when the user attempt to close the worksheet...

 

[Tigs81]

This should do the job

private sub workbook_beforeclose(cancel as boolean)
if((msgbox("Close",vbYesNo)) <> vbyes) then
cancel = true
end if
end sub

thanks
tigs