+ Reply to Thread
Results 1 to 4 of 4

Need help coding legacy check box values

  1. #1
    Registered User
    Join Date
    08-22-2019
    Location
    Madison, WI
    MS-Off Ver
    2013
    Posts
    5

    Question Need help coding legacy check box values

    Hello everyone,

    I am in need of some help fine tuning the below code and have yet to find a solution on the web due to my lack of coding knowledge. The code below will populate a blank excel file with all the text fields from word documents I have saved to a specific folder. The problem I am running into is that the check boxes do not populate if they were checked or not, they all just populate blank. How could I update the below code to extract the responses to the check boxes? The word form that is being used is locked so I am unable to change the check box properties. From what I have figured out is that it's using legacy text boxes/check boxes as once I updated the code from:

    Please Login or Register  to view this content.
    to:

    Please Login or Register  to view this content.
    it started working, pulling all the data like I wanted it to, minus the check box response. What would I need to update to get this to work correctly so the check box fields populate if they were marked or not?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Need help coding legacy check box values

    Welcome to the forum!

    Attach a short example if you need us to test it.

    The concepts here will likely help. Once you know the field type, the properties can be exposed more easily. http://www.excelforum.com/excel-prog...from-word.html

  3. #3
    Registered User
    Join Date
    08-22-2019
    Location
    Madison, WI
    MS-Off Ver
    2013
    Posts
    5

    Re: Need help coding legacy check box values

    Thank you for the welcome. I tried to attach test copies of both the excel and word file for review but after uploading, when trying to reply it wont allow me to insert/attach them. As far as the other thread goes that was referenced, it all went right over my head. I have zero coding experience. I just manage to stumble my way through most VBA stuff from info I find on the web until I get what I want to work

    Edit: spelling/grammar
    Last edited by NikoTheBowHunter; 08-22-2019 at 03:46 PM.

  4. #4
    Registered User
    Join Date
    08-22-2019
    Location
    Madison, WI
    MS-Off Ver
    2013
    Posts
    5

    Re: Need help coding legacy check box values

    I was able to find a solution online and modify it to fit my needs. Here is the solution:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Check in/Check out coding
    By THD1FH in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2019, 02:11 PM
  2. [SOLVED] check box coding for select / unselect at once problem
    By majidsiddique in forum Excel General
    Replies: 10
    Last Post: 04-13-2019, 08:24 AM
  3. [SOLVED] Coding Yes/No option buttons to not allow check boxes or require check boxes
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2014, 11:32 PM
  4. Coding to activate a check box from excel to SAP
    By lucianir in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2012, 05:30 PM
  5. Check box coding
    By sentinela in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2009, 05:28 PM
  6. Legacy Add-In Functionality Lost
    By dminn in forum Excel General
    Replies: 0
    Last Post: 03-28-2007, 11:43 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1