Jul 28 2005, 10:36 PM
I have two check boxes on an excel spreadsheet and what I would like to do is: when the user clicks on one check box I would like to see a yes/no message box where if the user clicks yes another control on my excel spread sheet is enabled.
Any help with this code would be greatly appreciated.
Jul 29 2005, 12:10 AM
Thanks anyways but I figured it out and its the same as Access.
Private Sub ChkThread_Click()
If ChkThread.Value = -1 Then
If MsgBox("Does this servo drive use a resolver?", vbYesNo, "Resolver Needed?") = vbYes Then
Me.ChkSpindRes.Enabled = True
Me.ChkSpindRes.Enabled = False