message box\Forms button
 

I have created a button that erases data from a spreadsheet by way of macro.
How can I have a mesage box show up when the button is pressed asking if they
really want to do this? If YES, run the macro, IF NO, close message box back
to the spreadsheet.

I am stumped on this...Please help.

thank you,

Jase

message box\Forms button
 

I appologize for the duplicate question. When I first posted it, I received
a message that the "service was temporarily unavailable", and I got no
indication if it had gone though or not.

Jase

"Jase4now" wrote:

I have created a button that erases data from a spreadsheet by way of macro.
How can I have a mesage box show up when the button is pressed asking if they
really want to do this? If YES, run the macro, IF NO, close message box back
to the spreadsheet.

I am stumped on this...Please help.

thank you,

Jase

message box\Forms button
 

I appologize for the duplicate question. When I first posted it, I received
a message that the "service was temporarily unavailable", and I got no
indication if it had gone though or not.

Jase



"Jase4now" wrote:

I have created a button that erases data from a spreadsheet by way of macro.
How can I have a mesage box show up when the button is pressed asking if they
really want to do this? If YES, run the macro, IF NO, close message box back
to the spreadsheet.

I am stumped on this...Please help.

thank you,

Jase