Consulting

Results 1 to 3 of 3

Thread: Use Excel VBA to check context control checkboxes in a Word file.

  1. #1

    Exclamation Use Excel VBA to check context control checkboxes in a Word file.

    Dear all,

    Before I go into my question I want to give you information about what I am working with.

    Version of the programs


    • Word 2013
    • Excel 2013
    • VBA 7.1


    Explanation of problem
    I have a Word document that has both checkboxes and textboxes in it. I am looking for an Excel VBA code that can check a specific checkbox in the Word document based on an excel cell saying “Yes” (checked) or “No” (not checked). Each checkbox thus needs to be linked to a different cell.

    Word has 3 types of checkboxes:


    • Check box content control
    • Check box form field (legacyforms)
    • Check box (activeX controls)


    I am using the Check Box Content Control. For this checkbox I do not find any clear excel VBA codes online that are used to check these boxes in Word. Is there anybody that knows how this can be done. Please also inform me if it only works with the other checkboxes.

    Many thanks in advance .

    kind regards,

    Sustainable

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    There is plenty of code in http://www.vbaexpress.com/forum/foru...lications-Help (to which your thread has been moved) for automating Word from Excel. This one: http://www.vbaexpress.com/forum/show...light=checkbox even shows how to differentiate between checkbox content controls and other types of content control.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Hey Paul,

    Many thanks for helping me. I will look into them to see if it solves my issue.

    Kind regards,

    Sustainable

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •