+ Reply to Thread
Results 1 to 3 of 3

Copy Cell to different Worksheet if checkbox selected

  1. #1
    Registered User
    Join Date
    07-26-2013
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    7

    Copy Cell to different Worksheet if checkbox selected

    Hi!
    My workbook has two sheets; "Estimate" & "Checklist".
    On "Checklist" WS; Column A is a checkbox, Column B is text, Column D is the linked cell to the checkboxes showing the TRUE/FALSE statement.
    I want the text in column B to copy and paste into "Estimate" WS when the aligning checkbox is checked, and to also clear from "Estimate" if unchecked. It should paste from B15 downwards into the next blank cell. The order doesn't matter, either in the original listed order or the order it is selected/checked (which ever is easier). I can get my code working on if I am having it copied to a blank sheet, but if trying to get it into "Estimate" is just clearing all the text in the sheet without copying anything.

    Heres the code I have in a module;

    Please Login or Register  to view this content.
    and then I have this code against each checkbox;

    Please Login or Register  to view this content.
    I've attached the basic workbook without any macros set up in it.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Copy Cell to different Worksheet if checkbox selected

    Hi Stacey,

    I had a quick look at the Estimate sheet.

    You have merged cells all over the place. Cut and paste will fail in this scenario. Get rid of the merged cells, and see if it works.

    I saw a Guru on this forum has two rules. 1. NEVER use merged cells. 2. Always follow rule 1!

    I avoid them like the plague! They create havoc with macros as you can see.

    I hope this helps, please let me know!

    Regards,

    David


    - Please click on the *Add Reputation button at the bottom of helpful responses.

    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".


  3. #3
    Registered User
    Join Date
    07-26-2013
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Copy Cell to different Worksheet if checkbox selected

    Thanks David, I had a feeling it may have had something to do with the merged cells as I saw the errors mention merged cells a couple times.

+ 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 fill next cell with date and username when a checkbox is selected
    By EHowarth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2015, 06:14 AM
  2. Selected checkbox values to one cell separeted by comma
    By lemke27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2015, 03:18 PM
  3. Copy range and paste depending on the selected checkbox
    By mackypogi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2014, 10:38 PM
  4. Excel: Macro to copy selected cells from Worksheet to a specified Worksheet(s)
    By hzman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2013, 04:26 AM
  5. Copy Columns is Checkbox is Selected
    By NALynch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-13-2012, 02:05 PM
  6. Replies: 0
    Last Post: 05-11-2011, 04:11 AM
  7. Copy rows to second worksheet by checkbox
    By sagsie in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-23-2010, 12:45 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