Message box after drop down list has been used

[pgrad]

Hi All,

I am hoping to create a msg box after the user has selected from one drop down list which will instruct them to select from the next drop down list.

Is this possible? Or is there an alternative way to highlight / force them to complete all the drop down lists in a specific order?

Thanks
Paul

 

[davidhall]

I have a macro that each user must run to generate some data calculations. I need to insert something at the end of the code that makes a message box on Sheet1 appear and asks the question " Question for User to Answer " and mandates the user to select either option 1 ( which should display "No") or select option 2 (which should display "Yes"). They have to click on yes or no to move on. If the user clicks on "No", cell G1 on Sheet1 will display a 0. If the user clicks on "Yes", cell G1 on Sheet1 will display a 1.


Any suggestions?

 

[Andrew Poulsom]

Here's an example:

Sub Test()
    Dim Answer As Long
    Answer = MsgBox("Question for User to Answer?", vbYesNo + vbQuestion, "Please Answer")
    With Worksheets("Sheet1").Range("G1")
        If Answer = vbYes Then
            .Value = 1
        Else
            .Value = 0
        End If
    End With
End Sub

 

[davidhall]

Thank you so much for the quick reply. That works great