Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-17-2021, 10:59 PM
nuraish nuraish is offline Assigning Values to content control checkboxes and calculating results Windows 10 Assigning Values to content control checkboxes and calculating results Office 97-2003
Novice
Assigning Values to content control checkboxes and calculating results
 
Join Date: Aug 2021
Posts: 1
nuraish is on a distinguished road
Default Assigning Values to content control checkboxes and calculating results

Hi, need to assign values to the checked boxes (5-1 as the rating points) and calculate the sum of total performance evaluation. How do i assign using macro?
Attached Files
File Type: docm OFFC 003 - Appraisal of Staff on Probation.docm (45.2 KB, 4 views)
Reply With Quote
  #2  
Old 08-18-2021, 03:14 AM
gibra's Avatar
gibra gibra is offline Assigning Values to content control checkboxes and calculating results Windows 10 Assigning Values to content control checkboxes and calculating results Office 2019
Novice
 
Join Date: Mar 2021
Posts: 8
gibra is on a distinguished road
Default

I'm not sure what you intend with SUM, because Checkboxes are True o False.Did you mean Count, instead?

However you can discovery the value of each checkbox with this code:
Code:
Option Explicit


Sub Esamina()
    Dim n As Long
    Dim s As ContentControl
    For Each s In ActiveDocument.ContentControls
        n = n + 1
        Debug.Print n, s.ID, s.Checked
    Next
End Sub
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assigning Values to content control checkboxes and calculating results Assigning Macro to Drop Down list Content Control aussiew Word VBA 5 03-10-2019 02:55 PM
Assigning Values to content control checkboxes and calculating results Assigning values to form fields and calculating results AustralianKate Word Tables 10 05-15-2018 10:53 PM
Assigning Values to content control checkboxes and calculating results Content Control Checkboxes wlcdo2 Word VBA 3 01-05-2017 05:52 PM
Assigning Values to content control checkboxes and calculating results Assigning values to formfield checkboxes in a table mammiano Word Tables 13 01-12-2015 06:27 AM
Assigning Values to content control checkboxes and calculating results Assigning Values to content control checkboxes and calculating results creative cathy Word Tables 13 10-07-2012 08:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:24 PM.


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