+ Reply to Thread
Results 1 to 7 of 7

Transfer Data from Checkbox List to Summary Table

  1. #1
    Registered User
    Join Date
    02-09-2021
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    4

    Transfer Data from Checkbox List to Summary Table

    Hi Everyone,

    I am new to the forum and this is my very first post so I will try my best to explain the problem.


    I am creating a from where the user has to select checkbox to indicate which emergency drill was completed. if the drill is not on the list there is a field for "other" to indicate the appropriate drill. I have also created a register on another tab to provide a summary of the drills that were performed. The idea is, once the form is complete a "complete register" button is selected which transfers the relevant data to the register. My problem is, I don't know how to change my VBA to transfer the data from the checklists to the register. I also don't know how to set it up to look at the "other" option if a checkbox is not selected.

    Just a note, I'm very new at this and everything I know I have thought myself through googling and YouTube videos so if possible please explain in a way for someone like me to understand

    Thank you!
    PS: I hope the explanation makes sense.
    Attached Files Attached Files
    Last edited by TheNovest98; 02-16-2021 at 08:02 PM.

  2. #2
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    2,389

    Re: Transfer Data from Checkbox List to Summary Table

    A file is worth a thousand pictures.Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    02-09-2021
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    4

    Re: Transfer Data from Checkbox List to Summary Table

    Apologies, I have added an example worksheet as suggested. I hope this explains my question better.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Transfer Data from Checkbox List to Summary Table

    This might get you started.

    If a drill type hasn't been selected and the Other field is empty the user will be prompted to fill the Other field.

    Note, you'll probably need to change the sheet names, and it's not clear where the value for the 'Submitted By' column should come from.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  5. #5
    Registered User
    Join Date
    02-09-2021
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    4

    Re: Transfer Data from Checkbox List to Summary Table

    Thank you for the code. I tried it but unfortunately it does not fill the Drill Type in the register when a check box is ticked, only when the Other field is filled in.

  6. #6
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    2,389

    Re: Transfer Data from Checkbox List to Summary Table

    Try the code below.
    you would be better using option buttons as multiple checkboxes can be selected by accident.

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    02-09-2021
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    4

    Re: Transfer Data from Checkbox List to Summary Table

    Thank you so so much! You just made my day!!

+ 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. help on vba code to Create table of summary from list of data
    By sarva200481 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2019, 06:34 AM
  2. Transfer Data according to Radio Button and Checkbox
    By 323100N in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2018, 02:59 AM
  3. [SOLVED] How to display data from checkbox list in a summary table
    By mitchellfamily13 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-11-2013, 10:23 AM
  4. Manipulate and arrange table data into summary list
    By DavidSpackman in forum Excel General
    Replies: 2
    Last Post: 07-28-2010, 12:57 AM
  5. Replies: 0
    Last Post: 06-25-2010, 06:19 AM
  6. [SOLVED] lookup? list data into summary table
    By Joe in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-21-2005, 08:30 PM
  7. script converting list data to summary table
    By matthew kramer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2005, 02:15 PM

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