Full Version: Check Box yes/no help
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
Golfnutt
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.

Thanks
Golfnutt
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
Else
Me.ChkSpindRes.Enabled = False
End If

End Sub
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.