Different response for button click

[USAMax]

I have a subroutine that works the way I want but I also want to tie it to a button with a message, "Are you sure you want to..."

Is there is a way to tell if the program is called from another routine or from the button click.

 

[JoeMo]

Thank you again Joe, the way you had it in the IsError I just assumed and did not attempt to try it that way.

I like to learn something every day but thanks to you I learned two things!

Me too. Glad I could help and thanks for your reply.