Results 1 to 3 of 3

Thread: Copy range and paste depending on the selected checkbox

  1. #1
    Junior Member
    Join Date
    Jul 2013
    Posts
    18
    Rep Power
    0

    Copy range and paste depending on the selected checkbox

    Im looking for a macro that can get a cell RANGE, the data in the RANGE will be copied then if the checkbox is selected it will copy the same data in the RANGE and add the selected checkbox in next column

    Please see my sample below
    here is my range below
    Capture1.PNG

    here is the user form
    Capture2.PNG

    here should be the result.
    Capture3.jpg

  2. #2
    Member
    Join Date
    Jun 2013
    Posts
    93
    Rep Power
    12
    no jpg please but an excel sample file for testing

  3. #3
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    mackypogi, the snapshots aren't entirely conveying your requirement properly. Could you either rephrase, or, as patel suggested, attach a sample with the expected output
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Copy/Paste Excel Range/Chart into Powerpoint VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 03-13-2014, 02:59 PM
  2. Replies: 1
    Last Post: 07-10-2013, 11:38 AM
  3. Replies: 2
    Last Post: 06-24-2013, 07:40 PM
  4. Replies: 3
    Last Post: 05-14-2013, 03:25 PM
  5. Trapping Copy To Range Before Copy/Cut Paste
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-07-2011, 07:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •