My Assistant
![]() ![]() |
|
|
Jul 28 2005, 10:36 PM
Post
#1
|
|
|
UtterAccess Guru Posts: 654 From: Michigan |
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 |
|
|
|
Jul 29 2005, 12:10 AM
Post
#2
|
|
|
UtterAccess Guru Posts: 654 From: Michigan |
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 |
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 24th May 2013 - 08:13 PM |