+ Reply to Thread
Results 1 to 2 of 2

Checkboxes in Userform Creates Multiple Data Entries

  1. #1
    Registered User
    Join Date
    12-16-2011
    Location
    SF
    MS-Off Ver
    Excel 2007
    Posts
    2

    Checkboxes in Userform Creates Multiple Data Entries

    Example:

    Userform has three text boxes (1,2,3) and three check boxes (a,b,c).

    I would like to add a new line of data for each checkbox that is checked with information from the values of the three textboxes and the caption of the checkbox. So if a and b were checked the data lines would look like this. Is this possible?

    1 value.......2 value........3 value.......a caption
    1 value.......2 value........3 value.......b caption

  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: Checkboxes in Userform Creates Multiple Data Entries

    I am assuming you are using ActiveX controls. I am also assuming that the three lines of data you are talking about are rows in a worksheet, and each item is in a different column. To do this, you need something like the attached example.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM
  2. Replies: 0
    Last Post: 02-06-2013, 02:24 PM
  3. [SOLVED] Auto increment next cell when adding multiple entries from userform
    By chriscoetser in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-02-2013, 02:15 AM
  4. VBA modules update creates duplicate entries
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-13-2012, 11:22 AM
  5. Userform checkboxes
    By MichelleW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2011, 03:53 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