+ Reply to Thread
Results 1 to 3 of 3

Multiple Checkbox values to one cell

  1. #1
    Registered User
    Join Date
    05-05-2017
    Location
    SoCal
    MS-Off Ver
    2010
    Posts
    2

    Multiple Checkbox values to one cell

    Hello all...first post for me.
    I'm brand new to VBA, and learning very slowly.
    I've tried searching the forum for an answer first, but couldn't find what I was looking for.

    I've created a userform that transfers data from text boxes into appropriate cells, and now have a series of checkboxes that I would like to do the same thing to.

    I have 3 separate 'groups' of similar check boxes. 1 'group' contains only 1 checkbox, and I was able to to get that value converted to text and input into the correct cell.

    But now I have a group of 5 different check boxes that I would like returned into a singular cell, separated by a comma.

    Here is what I have so far (a lot still left to do to clean it all up, but I'd like to solve this before I move on)

    Please Login or Register  to view this content.
    I hope this makes sense. Please let me know what I can try and if you need any more info.

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

    Re: Multiple Checkbox values to one cell

    What are the names of the five checkboxes? How do you determine the strings to show for each of them--is it the same as the captions for the checkboxes? What cell gets the output? For example:

    Please Login or Register  to view this content.
    The number of lines of code could be reduced but I don't want to confuse the issue; the above is straightforward.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    05-05-2017
    Location
    SoCal
    MS-Off Ver
    2010
    Posts
    2

    Re: Multiple Checkbox values to one cell

    Thank you very much. It didn't work 100% like I wanted, but it got me started, and after playing around with it, it works like a champ.

    Thank you for the quick reply. This forum is such a great resource!

+ 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. Selected checkbox values to one cell separeted by comma
    By lemke27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2015, 03:18 PM
  2. [SOLVED] Userform: Have multiple checkbox values populate to one cell
    By ciresuark in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-22-2014, 12:44 PM
  3. creating checkbox with multiple values
    By mosslovell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2014, 11:29 AM
  4. [SOLVED] Sum Multiple Checkbox Values in Single Cell
    By janicesm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-01-2014, 01:30 PM
  5. How to display values in multiple lines if multiple checkbox's are selected?
    By kjshep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2012, 10:10 AM
  6. Populate checkbox values in user form to cell
    By pavu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2012, 08:26 AM
  7. [SOLVED] Populate checkbox values in user form to cell
    By in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-01-1970, 12:00 AM

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