Msgbox Yes/No Button values 1

[protector]

Hello everyone

Can anyone tell me how I get the button click values from a message box. I need the values to complete an if else statement in the code.

Thanks in advance for the help

Craig

 

[SkipVought]

Hi,

Here's all there is to it...

    ans = MsgBox("Yes or no?", vbYesNoCancel)
    Select Case ans
        Case vbYes
            'yes stuff goes here
        Case vbNo
            'no stuff goes here
        Case vbCancel
            'cancel stuff goes here
    End Select

Hope this helps Skip,
SkipAndMary1017@mindspring.com

 

[protector]

Hi Skip

Thanks for the quick reply, code works great, thanks for the help

Craig