+ 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 Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,065

    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.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    Earth
    MS-Off Ver
    2016
    Posts
    692

    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 left 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