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 / Word / Programming / December 2006

Tip: Looking for answers? Try searching our database.

Forms, check boxes linking to a list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Vanna - 08 Dec 2006 04:57 GMT
Any help would be very much appreciated....

I would like to create a group of 3 check boxes say containing Editor,
reviewer and Approver.  These check boxes should be mutually exclusive.  If
the user selects the editor check box, a drop down list containing only
Editors for the user to choose and if the user checks the Reviewer, then the
list of reviewers names appear and so on.

In advance, than you for your help.
AlexM4096 - 11 Dec 2006 01:00 GMT
Is this what you're after?

Create a form with three checkboxes named 'ApprChBox', 'EditChBox', and
'RevwChBox', and a combobox named 'TheListCombo' and put this code in the
form:

'-->In a form
Private Sub ApprChBox_Change()
Dim A$
'Save the last selected item
A$ = TheListCombo.Text

'Clear the list
TheListCombo.Clear

'Add Approved names if checked
If ApprChBox.Value = True Then
   Call TheListCombo.AddItem("Appr1", TheListCombo.ListCount)
   Call TheListCombo.AddItem("Appr2", TheListCombo.ListCount)
End If
'Add Edit names if checked
If EditChBox.Value = True Then
   Call TheListCombo.AddItem("Edit1", TheListCombo.ListCount)
   Call TheListCombo.AddItem("Edit2", TheListCombo.ListCount)
End If
'Add Reviewed names if checked
If RevwChBox.Value = True Then
   Call TheListCombo.AddItem("Review1", TheListCombo.ListCount)
   Call TheListCombo.AddItem("Review2", TheListCombo.ListCount)
End If

'If the last selected item is in new list then leave, if not then delete
For I = 0 To TheListCombo.ListCount - 1
   If LCase(TheListCombo.List(I)) = LCase(A$) Then
       TheListCombo.Text = A$
       Exit For
   End If
Next I
End Sub
Private Sub EditChBox_Change(): ApprChBox_Change
End Sub
Private Sub RevwChBox_Change(): ApprChBox_Change
End Sub
'-->End of Code

I hope this helps you any

> Any help would be very much appreciated....
>
[quoted text clipped - 5 lines]
>
> In advance, than you for your help.
 
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.