+ Reply to Thread
Results 1 to 3 of 3

delete listbox item and off sheet

  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    745

    delete listbox item and off sheet

    hi
    I have been looking through threads trying to remove item in listbox which I have but want to delete from sheet as well ,have had various attempts,most do not delete item from sheet and some delete the sheet altogether,any ideas please,commandbutton5 deletes off listbox
    cheers colin
    Attached Files Attached Files
    Last edited by cfinch100; 08-16-2014 at 07:44 AM.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,692

    Re: delete listbox item and off sheet

    Just had a brief look at your file, it's impossible to delete what you have selected in the form in the sheet, because you do not have a unique ID to represent each row. You may only at best use list box's vs sheet's relative position (i.e. 7th item in list = 7th occurrence of that selected ID in worksheet) to delete, but it's not advisable to do so.

    What you can do is to populate row number into your list box, and delete that selected item's row number off the sheet. But note that using such method, you will need to "refresh" the form entirely after deletion.
    多么想要告诉你 我好喜欢你

  3. #3
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    745

    Re: delete listbox item and off sheet

    hi
    millz
    thanks for that no wonder whatever code I used did not work
    many thanks for looking and info
    cheers colin

+ 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. [SOLVED] Update (strikethrough) Listbox item selected within sheet
    By ShaunRoos in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2014, 02:45 PM
  2. [SOLVED] listbox item selection to got to specific sheet
    By sumonrezadu in forum Excel General
    Replies: 14
    Last Post: 05-17-2013, 12:38 AM
  3. Delete an item from listbox
    By questionguy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2013, 12:27 PM
  4. Delete a Item from a Listbox.
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-20-2010, 11:56 AM
  5. How to copy selected listbox item to sheet
    By michdan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2005, 08:05 AM

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