UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Check Box yes/no help    
 
   
Golfnutt
post 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
Go to the top of the page
 
+
Golfnutt
post 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 the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 01:27 AM