'Yes' 'No' button on autoopen macro

[Larry]

I have an autoopen MsgBox macro created. Instead of the "OK" button, I want the user to choose between "Yes" and "No" buttons. Yes=a pathway to a designated network drive and folder, No=remain on current worksheet. Q1. Syntax to instruct Excel to include Yes and No buttons in the MsgBox prompt. Q2. Syntax to instruct Excel what to do when either button is clicked. Thank you for any help you may offer. Your expertise is greatly appreciated

 

[officeguy]

rc = MsgBox ("Hello",vbYesNo

if the user selects Yes, rc =
if the user selcts No, rc = 7

 

[steveB]

Larry,

Try this code:

'''''''''''''''''''
Dim ans As String
'
ans = MsgBox("Do you want to stay in this workbook?", vbYesNo)
If ans = 6 Then
MsgBox ("You have chosen to stay in this workbook")
ElseIf ans = 7 Then
MsgBox ("You have chosen to do something else")
Else
MsgBox ("You didn't make a choice")
End If
''''''''''''''''''''''''''''

hth
--

steveB

(Remove 'NOSPAM' from email address if contacting me direct)

I have an autoopen MsgBox macro created. Instead of the "OK" button, I

want the user to choose between "Yes" and "No" buttons. Yes=a pathway to a
designated network drive and folder, No=remain on current worksheet. Q1.
Syntax to instruct Excel to include Yes and No buttons in the MsgBox prompt.
Q2. Syntax to instruct Excel what to do when either button is clicked.
Thank you for any help you may offer. Your expertise is greatly
appreciated.