Thanks David, however
IT clears the page regardless of it i hit Yes or No.

Do i have to put the Else, way down at the end of the macro?

"David Hepner" wrote:

Try this:

Sub Clear_Screen()

Dim response As Integer
Dim msg As String

msg = "Are you sure you want to clear all this information"
response = MsgBox(msg, vbYesNo, "WARNING")
If response = vbYes Then
'Enter existing code that clears the screen
Else
'Do something else
End If

End Sub




"John" wrote:

I think this is doable and easy, but i can not figure it out for the life of
me.

I have a macro that clears on the information from the screen. Can you have
something in the macro, that will prompt the user to ask a question, such as,
"Are you sure you want to clear all this information" The user can then
click yes or no. I guess it is similar to a validation.