+ Reply to Thread
Results 1 to 10 of 10

Multiple checkboxes to populate single cell

  1. #1
    Registered User
    Join Date
    10-06-2016
    Location
    Atlanta
    MS-Off Ver
    2013
    Posts
    11

    Question Multiple checkboxes to populate single cell

    Good morning all. I'm really hoping someone can guide me through this...
    I have a tracker, when double-clicking a cell in "D", it opens a userform. This userform is a MultiPage with multiple checkboxes per page. The idea is that the user can select all of the nonconformances on an inbound shipment and populate the spreadsheet. I've created the userform with a command button on each of the three pages but also a single command button outside of the multipage box (ideally, they click all boxes between the 3 multipage tabs and then hit a single command button to populate everything at once and clear the form).
    Unfortunately, I need all checkboxes to populate a single cell, hopefully one line at a time with a bullet point and the cell simply gets taller as needed. I seriously doubt I've explained this well enough, so I've added a sample form. Just double click in the "D" column and hopefully you'll see what I mean (and hopefully I attached it correctly).
    Thank you all so much for your assistance!
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Multiple checkboxes to populate single cell

    Are you populating column D in the row that was double-clicked?

    Some of your checkboxes are questions, and some are statements. I suggest you make them consistent.

    This version builds the cell using the checkbox captions when the user hits the Submit button. In my test I changed the name of your button to CommandButtonSubmit, so you will need to make that change for this code to work.
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,304

    Re: Multiple checkboxes to populate single cell

    Similar approach
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-06-2016
    Location
    Atlanta
    MS-Off Ver
    2013
    Posts
    11

    Re: Multiple checkboxes to populate single cell

    Perfect! Thank you so much!

  5. #5
    Registered User
    Join Date
    10-06-2016
    Location
    Atlanta
    MS-Off Ver
    2013
    Posts
    11

    Re: Multiple checkboxes to populate single cell

    OK, your code was perfect and did what I wanted, but the customer has asked a question, if I can create 3 columns (D, E and F), one for each of the non-conformance types (Container...page1, Shipment...page2, Documentation...page3), then populate the spreadsheet based on each of the three pages in the multipage form.

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Multiple checkboxes to populate single cell

    Whose code was perfect? Are you referring to my solution or torachan's?

    Also, giving you a push to get over a sticking point is one thing, but it sounds like you are asking for someone to a free project for you when you are getting paid to do this for a customer.

  7. #7
    Registered User
    Join Date
    10-06-2016
    Location
    Atlanta
    MS-Off Ver
    2013
    Posts
    11

    Re: Multiple checkboxes to populate single cell

    Both solutions worked, and it was just a request from our on-site customer to see if I could do it, I can assure you I don't get paid for this, I'm a Quality manager, not IT or anything else like that. And I understand, I'm not asking for anyone to do all the work for me, I have some work-arounds that I've done, but considering my experience in coding is so limited, there's always a better way (i.e. cleaner) to do it.

  8. #8
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Multiple checkboxes to populate single cell

    Here is the updated code. You still start by double-clicking in column D, but you can change that as needed.
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    10-06-2016
    Location
    Atlanta
    MS-Off Ver
    2013
    Posts
    11

    Re: Multiple checkboxes to populate single cell

    Perfect again, and I learned a few things from this exercise to boot! Thank you

  10. #10
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Multiple checkboxes to populate single cell

    I didn't give an explanation but please note that UserForm multipages are numbered started at 0. Most other objects in VBA start at 1.

+ 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. Multiple Checkboxes inside Single Excel cell
    By kripshome in forum Excel General
    Replies: 1
    Last Post: 05-14-2018, 10:53 AM
  2. [SOLVED] Userform to populate active cell using checkboxes - multiple responses applicable
    By Jonsocks in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2017, 08:30 PM
  3. Populate multiple textboxes after selection from a single combobox
    By VaibhavAr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-16-2016, 07:34 AM
  4. Single Job Print - UserForm & CheckBoxes & Multiple WorkSheets
    By MajorDev in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2016, 05:26 AM
  5. [SOLVED] Userform textboxes to populate with Cell data and sum if checkboxes ticked
    By RichardJSigKits in forum Excel General
    Replies: 12
    Last Post: 04-23-2014, 05:29 AM
  6. Using checkboxes to populate another cell
    By MGT2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2010, 12:56 PM
  7. A single Calendar macro that can populate multiple cells?
    By Codpops in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2008, 08:27 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