hi,
yes

msgbox("are you sure???",vbyesnow, warning)

look up msgbox in vb help (not excel help)

regards
FSt1

"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.