MsgBox Response Actions

[DLH]

Hello,

I need a little help ... I'm not an expert in VB Code, but I manage to get
around. I can write macros farily well but I'm stuck on this task.

I'm trying to set up a macro that utilizes the MsgBox function with Yes, No,
and Cancel responses. Based on what the user clicks, I want it to perform
different actions:

Example:

Question:
"Append comprehensive data?"

Options:
Yes, No, Cancel

Responses:
If they click Yes, run macro1
If they click No, run macro2
If they click Cancel, stop all macros

I've been searching and searching for an answer to this and have had no luck.

Any help is greatly appreciated! Thank you so much!!!

 

[DLH via AccessMonster.com]

Hi All,

Please disregard this post. I was able to figure it out myself. Thanks!