+ Reply to Thread
Results 1 to 10 of 10

Multiple checkboxes to populate single cell

Hybrid View

  1. #1
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    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.
    Private Sub CommandButtonSubmit_Click()
    
       Dim Ctrl As Control
       Dim PageNum As Long
       Dim ReportCell As Range
       
       Set ReportCell = ActiveCell
       
       
       For PageNum = 0 To 2
       
          ReportCell.ClearContents
          For Each Ctrl In Me.MultiPage1.Pages(PageNum).Controls
             If TypeName(Ctrl) = "CheckBox" Then
                If Ctrl.Value Then ' 10=line break, 149=bullet
                   ReportCell = ReportCell & Chr(149) & " " & Ctrl.Caption & Chr(10)
                End If
             End If
          Next Ctrl
          Set ReportCell = ReportCell.Offset(0, 1)
          
       Next PageNum
    
       Unload Me
    
    End Sub
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  2. #2
    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

+ 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