View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
steveB steveB is offline
external usenet poster
 
Posts: 30
Default 'Yes' 'No' button on autoopen macro

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)


"Larry" wrote in message
...
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.