+ Reply to Thread
Results 1 to 3 of 3

Filtered ListBox Selected item delete in sheet Entire Row

  1. #1
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    Filtered ListBox Selected item delete in sheet Entire Row

    Dear All,

    I have a list box and command button. The Filtered Selected item and the same EntireRow delete from the Sheet by clicking the Command Button. How can i accomplish that ?

    Thanks in Advance
    Last edited by sijostephen; 05-05-2019 at 12:15 PM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Filtered ListBox Selected item delete in sheet Entire Row

    When you load the listbox with data. Save the Row Number of the item as well. The Column Can be hidden.

    Then when you need to delete the row, you will already know the row number.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: Filtered ListBox Selected item delete in sheet Entire Row

    It's not clear what you mean. It's always best to provide a workbook with the structure necessary to demonstrate your issue and use examples.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.

+ 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] Moving all columns from listbox 1 to listbox 2 and see all details of an selected item
    By alexgoaga in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2018, 07:09 PM
  2. [SOLVED] VBA to remove item selected from ListBox and to find in row source and delete as well
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2016, 11:51 AM
  3. Code to delete entire row on sheet when selected in listbox
    By chrismccarthy17 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-02-2016, 12:18 AM
  4. Userform listbox - Getting Sheet row of selected item
    By johnny_p in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2015, 05:00 AM
  5. [SOLVED] delete listbox item and off sheet
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2014, 05:53 AM
  6. [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
  7. 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

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