Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2008

Tip: Looking for answers? Try searching our database.

CheckBox . . .

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SJohn - 23 Mar 2008 17:31 GMT
I am new at Excel. I have on a worksheet 5 check boxes (A3 to A8)
I have them linked to B3 to A8. When a checkbox is activated in A3 then B3
shows "TRUE".
I am trying to make sure that only one of the 5 checkboxes can be activated
at any one time.
Any ideas?
Peter T - 23 Mar 2008 17:37 GMT
Be conventional, use OptionButtons !

Regards,
Peter T

> I am new at Excel. I have on a worksheet 5 check boxes (A3 to A8)
> I have them linked to B3 to A8. When a checkbox is activated in A3 then B3
> shows "TRUE".
> I am trying to make sure that only one of the 5 checkboxes can be activated
> at any one time.
> Any ideas?
FSt1 - 23 Mar 2008 18:55 GMT
hi
if you want only one check box set to true then set the others to false at
the same time. i.e.
Private Sub CheckBox1_Click()
If CheckBox1 = True Then
   CheckBox2 = False
   CheckBox3 = False
   CheckBox4 = False
   CheckBox4 = False
End If
End Sub

each check box would need code similar to above but as each check box is
checked(set to true) the others are set to false(unchecked) so the second
check box code would look something like this....
Private Sub CheckBox2_Click()
If CheckBox2 = True Then
   CheckBox1 = False
   CheckBox3 = False
   CheckBox4 = False
   CheckBox4 = False
End If
End Sub
and so on for each check box.

Regards
FSt1

> I am new at Excel. I have on a worksheet 5 check boxes (A3 to A8)
> I have them linked to B3 to A8. When a checkbox is activated in A3 then B3
> shows "TRUE".
> I am trying to make sure that only one of the 5 checkboxes can be activated
> at any one time.
> Any ideas?
SJohn - 24 Mar 2008 01:58 GMT
Do I have to define the variables? eg. CheckBox1, 2, etc. etc.

> hi
> if you want only one check box set to true then set the others to false at
[quoted text clipped - 30 lines]
> > at any one time.
> > Any ideas?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.