+ Reply to Thread
Results 1 to 3 of 3

Delete selected cell row vice active cell

  1. #1
    Valued Forum Contributor
    Join Date
    02-26-2010
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003/2007/2010/2016
    Posts
    432

    Talking Delete selected cell row vice active cell

    Roy Cox made this data entry form with search capability. It works great, but I found a bug I don't know how to fix.

    When you do a Find, it lists the results of the search in a Listbox on the form.

    When you click on one of the results, you should be able to delete it if desired.

    The problem is that the code is deleting the active cell row vice selected cell row. I don't know enough about VBA to fix it reliably.

    Any help appreciated.

    Thanks!

    VR/Lost
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-26-2010
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003/2007/2010/2016
    Posts
    432

    Re: Delete selected cell row vice active cell

    All,

    In looking at it, I think the problem code is here. Nowhere does it say "select the cell that corresponds to the r".

    ??

    V/R Lost

    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor
    Join Date
    02-26-2010
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003/2007/2010/2016
    Posts
    432

    Talking Thread Summary

    All,

    This thread solution is summarized by the following thread:

    http://www.excelforum.com/excel-prog...ot-blanks.html

    At the bottom of that thread, you will find two workbooks: one which adds rows at the bottom of a sheet, and another which adds rows in a middle section of a sheet.

    99.9% of the tough stuff was by virtue of the Excel geniuses in this forum. Thanks all for helping complete a project which will make work easier for many, many people!

    Respectfully,

    Lost[/QUOTE]

+ 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