'Yes' 'No' buttons in auto-open macro

[Guest]

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.

 

[Don Guillett]

As usual, post your code but maybe an inputbox would help.

--
Don Guillett
SalesAid Software
(e-mail address removed)

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.

 

[Peo Sjoblom]

Look in the VBA help for vbYesNo
also don't you think this should have been posted in programming, it's
hardly
a function question?

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

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.

 

[Harald Staff]

Sub Test()
Select Case MsgBox("HookaHey", vbYesNo)
Case vbYes
MsgBox "I'll be back"
Case Else
MsgBox "Here's looking at you"
End Select
End Sub


HTH. Best wishes Harald

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.