+ Reply to Thread
Results 1 to 8 of 8

Check boxes not functioning as i expect

  1. #1
    Registered User
    Join Date
    04-12-2020
    Location
    ARIZONA, USA
    MS-Off Ver
    2019
    Posts
    7

    Check boxes not functioning as i expect

    Good morning all. I am trying to create a checklist where the user can select the options they need and then click a button to generate a note with only the selected checkboxes. ideally I would also like there to be a line between each item I've tried to put vbnewline in and while i know SOME vba I'm far from proficient. When I select the boxes what ends up happening is i only get one result generated in the textbox. Can anyone assist?
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Check boxes not functioning as i expect

    the reason that's happening is because you have 3 code lines, written over and over again for every box:
    Please Login or Register  to view this content.
    so what are you looking for? a line of text for EVERY box ticked? if yes, there's many ways. and you can throw a new line into a string var a number of ways too. try this as a start:
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Check boxes not functioning as i expect

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Check boxes not functioning as i expect

    Slight variation on the above suggestion, but same approach.

    Please Login or Register  to view this content.
    BSB

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

    Re: Check boxes not functioning as i expect

    Try something like this, and also set the MultiLine property of the textbox to True.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  6. #6
    Registered User
    Join Date
    04-12-2020
    Location
    ARIZONA, USA
    MS-Off Ver
    2019
    Posts
    7

    Re: Check boxes not functioning as i expect

    Adam,

    I cannot thank you enough, you solved this so quickly and proficiently! I am very grateful for your assistance.

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

    Re: Check boxes not functioning as i expect

    Please Login or Register  to view this content.
    Attached Files Attached Files

  8. #8
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Check boxes not functioning as i expect

    Quote Originally Posted by LoJay View Post
    Adam,

    I cannot thank you enough, you solved this so quickly and proficiently! I am very grateful for your assistance.
    LOL! yeah yeah. I was the first. every other person has the right answer. I just gave you the way that you would identify the most with. take care

+ 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. Check boxes that delete other check boxes and change the color of another cell.
    By nhamhamilton in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2014, 02:40 PM
  2. [SOLVED] Coding Yes/No option buttons to not allow check boxes or require check boxes
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2014, 11:32 PM
  3. Replies: 1
    Last Post: 05-23-2013, 10:42 AM
  4. Automatically check one or more check boxes when a parent check box is manually checked
    By Steverizer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2013, 01:56 PM
  5. I need a code for presence check to check multiple text boxes and combo boxes
    By Lee_wwfc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2013, 01:53 PM
  6. Excel VBA to generate check boxes and restrict user to tick on the 3 boxes in a row
    By rhodalynn.rona in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2012, 05:55 AM
  7. Automatic setting of check boxes based on other check boxes?
    By ArchiveMike in forum Excel General
    Replies: 5
    Last Post: 07-31-2012, 09:43 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