![]() |
#9
|
|||
|
|||
![]()
Hello people
![]() I was tempted to ask for help, since i end up trying to create some conditions a little more specific but after many hours of researching and reading i learned to catch my own fish thanks to you all people c: I was able to create the following code: Code:
Option Explicit Sub ExclusiveCheckBoxes() Dim strTemp As String Dim oFF As FormField Dim strGrpID As String Dim strSeqID As String Dim i As Long Dim strSeqNext As String strTemp = "ABCDEFGHIJKLMNOPQRSTUVWXYZ" Set oFF = Selection.FormFields(1) If oFF.CheckBox.Value = True Then strGrpID = Left(oFF.Name, 8) strSeqID = UCase(Right(oFF.Name, 1)) If strSeqID Like "[A-Z]" Then 'Clear all GroupID ChkBoxes including the CB selected (ensure only one CB in group is selected). For i = 1 To Len(strTemp) strSeqNext = strGrpID & "_" & Mid(strTemp, i, 1) If ActiveDocument.Bookmarks.Exists(strSeqNext) Then ActiveDocument.FormFields(strSeqNext).CheckBox.Value = False End If Next i 'Set the CB that was selected oFF.CheckBox.Value = True End If End If SetCheck lbl_Exit: Exit Sub End Sub Sub SetCheck() Dim bChecked As Boolean bChecked = False With ActiveDocument If .FormFields("CHK_1234_A").CheckBox.Value Or .FormFields("CHK_2345_A").CheckBox.Value Then .FormFields("PVresult").CheckBox.Value = True Else .FormFields("PVresult").CheckBox.Value = False If Not .FormFields("PVresult").CheckBox.Value Then .FormFields("PVresult").CheckBox.Value = bChecked End If End With End Sub Which allow me to have the following conditions: If at least 1 of the 2 "Yes" Checkbox its market, mark PV box, if no "Yes" box its checked, PV box will be unchecked aswell. If both "No" Boxes are checked, PV box will be unckecked too. Only one box per group can be marked, so you cant have "Yes" and "No" box maked on the same Line. Love you all ppl <3, any tip you guys think that could be useful go ahead, thanks alot for the help. |
Tags |
check boxes |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Check Box Form Field Book Mark Auto Fill? | zacam87 | Word VBA | 5 | 08-20-2014 02:56 PM |
how to show total of check boxes checked | worder | Word | 16 | 03-10-2014 05:07 PM |
![]() |
mawigfie | Word | 1 | 08-22-2012 01:16 PM |
![]() |
DKerne | Word VBA | 4 | 06-09-2011 11:54 AM |
Form field to automatically be added to header? | razberri | Word VBA | 3 | 02-22-2010 03:48 PM |