Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 09-07-2015, 03:31 PM
Eduardo Care Eduardo Care is offline Check box form field automatically checked Windows 8 Check box form field automatically checked Office 2010 64bit
Advanced Beginner
Check box form field automatically checked
 
Join Date: Aug 2015
Location: Cali
Posts: 32
Eduardo Care is on a distinguished road
Default

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.
Attached Files
File Type: docm test.docm (23.4 KB, 17 views)
Reply With Quote
 

Tags
check boxes



Similar Threads
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
Check box form field automatically checked Repeat Spell check in a doc that has already been checked mawigfie Word 1 08-22-2012 01:16 PM
Check box form field automatically checked Word Macro That Checks a Check Box Form Field When File Print is Executed 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft