+ Reply to Thread
Results 1 to 4 of 4

copy data of check box is clicked true

  1. #1
    Forum Contributor
    Join Date
    09-22-2007
    Posts
    119

    copy data of check box is clicked true

    Hi , can any one help edit the code ,i think that wrong
    my user form when click "ok " it is not copy 001-10007-8 and 001-10007-4
    to the yellow area.
    i want to copy only the data in d1:d6 ,when the check box is click "true "
    but it copy only the first data of check box .some check box is true also but it is not copy
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481
    There's a few ways to do this:
    Here's one for the command button:
    since the labels are already equal to the range you want to copy
    You can write
    Please Login or Register  to view this content.
    ect.
    or do away with the command button and have code for each check box
    Please Login or Register  to view this content.
    The above code only works when a check box is checked or unchecked, if you were to go that way, you would have to set the check boxes to false when you open the userform

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Try this

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Contributor
    Join Date
    09-22-2007
    Posts
    119
    Thanks,
    Dave,Royuk
    your code help me best

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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