Results 1 to 9 of 9

Copying Rows Represented By Checked Checkboxes

Threaded View

  1. #1
    Registered User
    Join Date
    08-23-2014
    Location
    Miami, USA
    MS-Off Ver
    365
    Posts
    69

    Copying Rows Represented By Checked Checkboxes

    Hi guys,

    After doing some reading within the forum I was able to get to the point to where I'm at.

    I Currently I have a table with a list of products and checkboxes besides each item, where if the checkbox is checked, it will copy the whole row to Sheet1. As shown below:

    2017-01-02_15-59-37.png 2017-01-02_16-03-37.png

    I want to be able to delete a row after I uncheck a particular item, if I change my mind.

    The formatting after it has been copied to my destination sheet is also messed up.

    I have attached the workbook if needed. I'm using a Private Sub for each of the Checkbox, if selected.

    Bonus help: If it all possible, I would like to have the items that are checked, to show on the right had side of my items, within the same sheet, as shown below:

    2017-01-02_16-10-37.png

    Thank you in advance for any help provided. If there is a better way to do this, I'm open to suggestions as well, I'm no expert in the matter.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dependent checkboxes where only one can be checked at a time.
    By dabrams83 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2016, 06:25 PM
  2. Copy rows if checkboxes are checked
    By KT99 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-01-2014, 03:14 PM
  3. Summing checked checkboxes
    By bermudamohawk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2014, 11:25 AM
  4. How to copy only checked checkboxes into new cell?
    By GTX2013 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2013, 09:06 PM
  5. [SOLVED] Combining SUMPRODUCT with Checked Checkboxes
    By pstewart in forum Excel General
    Replies: 6
    Last Post: 08-11-2012, 04:49 PM
  6. Checkboxes checked based on cell value
    By humboldtguy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-23-2010, 09:48 AM
  7. [SOLVED] My checkboxes will not stay checked.
    By NUMBnut in forum Excel General
    Replies: 0
    Last Post: 01-09-2006, 05:10 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