Check Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a check box in a form. I want a msg box to pop up everytime it is
clicked on. Asking the user if he/she wants to continue. If user says yes
then the box changes from unchecked to checked or from checked to unchecked.
If user says no then the box stays the same. Im having problems writing the
code for this.
Thanks to those who can help.
 
tanhus said:
I have a check box in a form. I want a msg box to pop up everytime it is
clicked on. Asking the user if he/she wants to continue. If user says yes
then the box changes from unchecked to checked or from checked to unchecked.
If user says no then the box stays the same. Im having problems writing the
code for this.
Thanks to those who can help.
Click to expand...

Ok Tanhus urs is not a big issue.
on checkbox click write following in VBA code.

Private Sub Check10_Click()
If MsgBox("Yes/No", vbYesNo) = vbYes Then Check10.Value = Not
Check10.Value
End Sub

Good Luck!!
 
Back
Top