Pop up hint messagebox

Thanks for you help

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

Code:

---

Private Sub Status_BeforeUpdate(Cancel As Integer)

End Sub

---

this is the event procedure

Quote:

---

Originally Posted by wedd

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

Code:

---

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:

Code:

---

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

---

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

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

Quote:

---

Originally Posted by 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

---

Again, please post the VBA code.

Quote:

---

Originally Posted by 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

---

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

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. :-)

thanks for your assistance

Quote:

---

Originally Posted by wedd

... 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.

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