Delete entire row from worksheet, which is selected in 'Listbox1' on Userform

**p_nayak268** · 08-26-2013, 06:42 AM

Hello,

There are 1 'ListBox' & 4 ComboBoxes on userform.

As soon as Userform activates, 'ListBox1' is populated with whole data from worksheet (Project). Also the ComobBoxes with Column (A,B,C & D) data from same sheet.

Based on 'ComboBox1, 2, 3 or 4' selection, the sheet (Project) is filtered and populated in 'ListBox1'. I thank again to 'jaslake' one of our excel-guru in this forum, for the help.

Now my problem is:

After 'CoboBoxes' filteration, I want to select any item in 'ListBox1' and delete from 'Project' sheet using commandbutton 'Delete'.

Somebody, please help me. Your time and help is appreciated.

Thank you

**shyamhappy** · 08-26-2013, 07:18 AM

Try this Attachment. This will work for you

_____________________________________________________________________________________________________________________________
Please click * to say thank You

**p_nayak268** · 08-26-2013, 07:32 AM

Hi Shyam,

The code works well before any 'ComboBox' filteration. It does not work if any item selected after filteration.

Thank you.

**shyamhappy** · 08-26-2013, 07:51 AM

I have put Trim function to avoid additional spaces at end and hope this works.

________________________________________________________________________________________________________
Please click * to say thank you

**p_nayak268** · 08-26-2013, 08:27 AM

Hi Shyam,

It's perfect.

I have to just work around to update the listbox right after delete. But, your code works perfect.

Thank you very with this quick help.

Delete entire row from worksheet, which is selected in 'Listbox1' on Userform

LinkBack

Thread Tools

Rate This Thread

Display

Delete entire row from worksheet, which is selected in 'Listbox1' on Userform

Re: Delete entire row from worksheet, which is selected in 'Listbox1' on Userform

Re: Delete entire row from worksheet, which is selected in 'Listbox1' on Userform

Re: Delete entire row from worksheet, which is selected in 'Listbox1' on Userform

Re: Delete entire row from worksheet, which is selected in 'Listbox1' on Userform

Thread Information

Users Browsing this Thread

Similar Threads

How to Show record from Sheet2 not Sheet 1 in the UserForm ListBox1.

[SOLVED] I need to delete a bunch of zero's (0) in a selected group and not the entire page.

Remove row source from userform listbox1 search results

Delete Range when checkbox in Userform is Selected

[SOLVED] UserForm:Resume to ListBox1

Bookmarks

Bookmarks

Posting Permissions