MsgBox response

I am trying to use a message box to get a response as I would in VB6. The options are there for a yes/no msgbox or any other. It doesn't work so I'm just wondering if this is even possible in VBA. (I'm using Excel 2000).

If I can't do this I need another suggestion. But first things first - Can I use a msgbox to get a response (yes/no)?

Sunflower Queen

Sunflower Queen,

Here's a sample for using the MsgBox:

Sub showMessage()
' Declare program variables...
Dim Msg, style, Title, Response
' Prompt user to determine to do something
' Define user dialog parameters
Msg = "This program updates some data. Do you want to continue?"
style = vbYesNo + vbExclamation + vbDefaultButton1
Title = "Data Updating"
' Display user dialog
Response = MsgBox(Msg, style, Title)
If Response = vbNo Then ' If user chooses no, stop the program
Exit Sub
Else
' If user chooses yes, insert your code here...
End If
End Sub

Hope this helps,
theDude