Pop up hint messagebox

[wedd]

Thanks for you help

[Imdabaum]

And if they click NO, would you want to perhaps undo their action?

[wedd]

Private Sub Status_BeforeUpdate(Cancel As Integer)

End Sub

this is the event procedure

[HiTechCoach]

I've managed to create an information message box...but I want to achieve that when the user clicks on the drop down list a yes/no button has to be click to confirm their action

Private Sub cboSheets_AfterUpdate()
    If Me.cboSheets = "Term Sheet" Then
        If MsgBox("Please confirm (Y/N) that the an active mandate has been agreed and therefore an engagment letter _
        has been agreed and signed with the client", vbYesNo, "Confirm") = vbYes Then
        Me.chkAgreed = True
    Else
        Me.chkAgreed = False
    End If
    Else
        Me.chkAgreed = False
    End If
    If MsgBox(prompt, vbYesNo, title) = vbYes Then
        MsgBox ("You clicked Yes")
    Else
        MsgBox ("You clicked no")
    End If
End Sub

Try this:

Private Sub cboSheets_AfterUpdate()
    If Me.cboSheets = "Term Sheet" Then
        If MsgBox("Please confirm (Y/N) that the an active mandate has been  agreed and therefore an engagment letter _
        has been agreed and signed with  the client", vbYesNo, "Confirm") = vbYes Then
        Me.chkAgreed = True
        MsgBox ("You clicked Yes")
    Else
        Me.chkAgreed = False
        MsgBox ("You clicked no")
    End If
    Else
        Me.chkAgreed = False
    End If
End Sub

[wedd]

I used a macro for the information message box but there isn't an option for a yes/no option...hence why i'm interested in writing a vba script...I add this code to a list box/combo box...the field with the drop down list is called status and the the database is called The Deal Log

[wedd]

I've added the code to the event procedure...when I click on the option I want nothing happens...the code is right..just not sure why it's not creating the prompt... :-S

[HiTechCoach]

I've added the code to the event procedure...when I click on the option I want nothing happens...the code is right..just not sure why it's not creating the prompt... :-S

Again, please post the VBA code.

[Imdabaum]

I used a macro for the information message box but there isn't an option for a yes/no option...hence why i'm interested in writing a vba script...I add this code to a list box/combo box...the field with the drop down list is called status and the the database is called The Deal Log

Unfortunately, there is no way to do a vbYesNo messagebox within a macro.

[wedd]

So, I realised and it seems as if it's impossible to add vba code yes/no to an existing combo box...thanks for your help I'll just create it as an alert messsage box through a macro...thanks for your assistance. :-)

[wedd]

thanks for your assistance

[HiTechCoach]

... impossible to add vba code yes/no to an existing combo box...

You can everything to an existing combo box that you can add to a new one.

[Imdabaum]

Can you please describe what you want to happen in the event they click yes, and also what will happen if they click no.