+ Reply to Thread
Results 1 to 7 of 7

Transfer Data from UserForm that their check box had checked!

  1. #1
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Transfer Data from UserForm that their check box had checked!

    Hello

    I have a userform with 12 checkboxes. Eatch one for a different case. It's case also has her own comment box.

    What i would like to fo is clicking a button, every case that her check box is checked to transfer the data ia the first availble row of sheet calling DataBase

    In my attachment i describe exactly my needs.

    Thanks in advance for any assistance on this!
    Attached Files Attached Files

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Transfer Data from UserForm that their check box had checked!

    You userform skips Case 5. Was this intentional?
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Transfer Data from UserForm that their check box had checked!

    Hi

    Thanks for looking on this.

    No it is an accident!!

  4. #4
    Registered User
    Join Date
    01-21-2013
    Location
    Europe
    MS-Off Ver
    Excel 2016 Win
    Posts
    11

    Re: Transfer Data from UserForm that their check box had checked!

    To find last row you can use this code:
    Please Login or Register  to view this content.
    You should connect checkboxes with appropriate labels and textboxes, for example select checkbox1, label2(Case1) and textbox2 and in properities give them Tag = 1

    After this you can find in loop which checkboxes are seleced:
    Please Login or Register  to view this content.
    When you want to put textboxes and labels with the same tag to the worksheet you can put similar loop inside first loop:
    Please Login or Register  to view this content.
    Inside second loop you check what kind of control it is and do with it whatever you want, for example:
    Please Login or Register  to view this content.

  5. #5
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Transfer Data from UserForm that their check box had checked!

    Please see attached userform_with_checkboxes(1).xlsm

  6. #6
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Transfer Data from UserForm that their check box had checked!

    jotpol

    Thank you for your intention to help me. Unfortunately i am not(still..!) able to connect all these together!

    Solus Rankin

    Exactly what i need. Thank you so much!!

    What ecactly this line does?

    Please Login or Register  to view this content.

  7. #7
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Transfer Data from UserForm that their check box had checked!

    That is a loop. It runs all the code in between that line and that line that shows
    Please Login or Register  to view this content.
    It runs the code for each increment changing the value of the variable i. To show the effects:

    Open a blank workbook. Right click the tab for sheet 1 and select 'view code'. Copy the code below into the module. Select the line that says Sub Test and press F8. F8 will allow you to run the code line by line observing the effects.

    Please Login or Register  to view this content.

+ 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. 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
  2. Replies: 2
    Last Post: 12-19-2012, 11:23 PM
  3. Check data then checked data autosummed
    By sirslinkster in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2012, 07:34 PM
  4. Copy data against each checked check box and paste in a new excel workbook
    By rnd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-28-2010, 06:04 AM
  5. [SOLVED] Moving Data from one tab to another when a check box is checked.
    By Bob1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2006, 07:25 PM

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