+ Reply to Thread
Results 1 to 4 of 4

Non UserForm - Checkbox Loop to add numbers and concatenate labels - Part B

  1. #1
    Registered User
    Join Date
    02-18-2012
    Location
    Dubai, United Arab Emirates
    MS-Off Ver
    MS Office 2021
    Posts
    48

    Non UserForm - Checkbox Loop to add numbers and concatenate labels - Part B

    So, I already received a solution to my problem in Part A, but I have additional requirements. I tried messaging the people who helped me there, but I guess since I marked the thread as solved and gave them reps, they aren't replying anymore. So have started a new thread for someone to follow up on the solution provided.

    The 2 solutions provided are with filenames ending PartA. And the query that I have for this thread is in the file PartB.

    Link to: Part A

    I hope someone can look into these files and help me out on this.
    Last edited by ecronic; 12-08-2020 at 04:58 AM.
    Thanks & regards
    Dev

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,666

    Re: Non UserForm - Checkbox Loop to add numbers and concatenate labels - Part B

    Try the following with the distribution on the right
    For labs 1&2 (cell R12):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    For labs 3,4,&5 (cell R17):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    02-18-2012
    Location
    Dubai, United Arab Emirates
    MS-Off Ver
    MS Office 2021
    Posts
    48

    Re: Non UserForm - Checkbox Loop to add numbers and concatenate labels - Part B

    Quote Originally Posted by JeteMc View Post
    Try the following with the distribution on the right
    For labs 1&2 (cell R12):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    For labs 3,4,&5 (cell R17):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Thanks JeteMc, but I got a better solution from another Forum. That solution is completely automate i.e. if the Lab(s) increase as well the Distribution automatically creates additional sections.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,666

    Re: Non UserForm - Checkbox Loop to add numbers and concatenate labels - Part B

    Thank You for marking the thread as 'Solved', although Internet etiquette suggests that it is proper to do so as soon as you have a solution so that people will not spend time working on requests that have already been answered.
    I hope that you have a blessed 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. [SOLVED] Non UserForm - Checkbox Loop to add numbers and concatenate labels
    By ecronic in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-01-2020, 10:36 AM
  2. [SOLVED] Loop through a userform listbox & copy certain columns into txtboxes on userform loop next
    By mtilbury in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2016, 10:10 AM
  3. [SOLVED] Make Worksheet Active-X CheckBox value same as Userform CheckBox value
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-21-2016, 08:23 AM
  4. [SOLVED] Userform labels to repeat/autofill exactly into other labels on the same userform
    By indub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-21-2015, 02:18 PM
  5. loop through userform labels?
    By losmi8 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2011, 06:34 AM
  6. Concatenate text and checkbox data entered in userform
    By Samantha McNeill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2011, 02:43 PM
  7. Use Checkbox to Select Labels for Printing
    By ilundy77 in forum Access Tables & Databases
    Replies: 1
    Last Post: 10-10-2010, 09:17 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