Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-05-2019, 05:11 AM
eduzs eduzs is offline How can I replace FormFields with text Windows 10 How can I replace FormFields with text Office 2010 32bit
Expert
 
Join Date: May 2017
Posts: 266
eduzs is on a distinguished road
Default

Try this in a disposable copy of your document (backup the original file):


Code:
Sub Test()

    Dim strCheckBoxSlct As String
    Dim strCheckBoxName As String
    Dim strCheckBoxValue As String
    Dim i As Integer
    
    For i = 1 To ActiveDocument.FormFields.Count
        If ActiveDocument.FormFields(1).CheckBox Then
            strCheckBoxValue = ActiveDocument.FormFields(1).CheckBox.Value
            ActiveDocument.FormFields(1).Select
            If strCheckBoxValue = True Then
                Selection.TypeText "0"
            Else
                Selection.TypeText "1"
            End If
        End If
    Next
    
End Sub
__________________
Backup your original file before doing any modification.
Reply With Quote
 

Tags
checkbox, formfields

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue Using FormFields.Result boCash Word VBA 0 04-04-2017 12:54 PM
Updating/Locking FormFields Maskot Word VBA 4 06-24-2015 04:40 AM
Macro to find coloured text and replace with form-field/formtext containing that text tarktran Word VBA 1 11-26-2014 08:12 AM
How can I replace FormFields with text Mailmerge and Formfields Liosis Mail Merge 4 03-07-2014 12:56 PM
Renaming Word Formfields: string too long error silverspr Word VBA 7 01-22-2013 06:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:17 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