+ Reply to Thread
Results 1 to 2 of 2

Delete check box

  1. #1
    Registered User
    Join Date
    11-06-2013
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    42

    Delete check box

    I have a spreadsheet that contains about 300 rows and in each row there is a checkbox that is linked to a cell in that row. If the checkbox is "checked", the macro I have developed copies the data in the row, moves it to another worksheet, pastes it, and then returns and deletes the row. What I have found however is that the checkbox remains after the row has been deleted.

    So I need a macro that will delete a checkbox in a row that is also being deleted. The rows can be deleted as individual rows or multiple groups of rows, not necessarily adjacent to each other. In other words, the rows to be deleted can be any one of the 300+ rows.

    The checkboxes are located in column B. The data to be removed is in columns C through M.

    Can anyone help?

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Delete check box

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. Check boxes that delete other check boxes and change the color of another cell.
    By nhamhamilton in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2014, 02:40 PM
  2. Using Check Box To Delete Row
    By mcurrier in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-17-2009, 08:34 PM
  3. Check delete condition.
    By pichai in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-29-2007, 01:36 AM
  4. [SOLVED] delete a check box
    By lldjc in forum Excel General
    Replies: 2
    Last Post: 04-15-2006, 02:00 PM
  5. Check Box wont Delete
    By Brandt in forum Excel General
    Replies: 3
    Last Post: 06-08-2005, 11:05 AM

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