Not deleting the selected data from listbox by one click on command button

I even gave it a range to delete, however, i have to click the delete button twice to delete what is entered. First click merges the 2 columns and 2nd click deletes.
I want to only delete what i have selected from the listbox with one click of the command button. Listbox has 2 columns. I am using the code below

Please Login or Register  to view this content.

Originally Posted by 6StringJazzer

What do you want to happen? Do you really want a "delete," which will delete the value and move other cells to fill the deleted cell? When you don't explicitly give an argument for Delete, then Excel decides for you how best to do the fill. You said "First click merges the 2 columns..." What 2 columns? I don't see anything here that would merge columns at all.

Two other points. I would recommend declaring all variables; c1 should be declared as a Range. Also, your With...End With is superfluous. The code does not take advantage of it so it's not clear what you had in mind.

It might helpful to attach your entire workbook instead of just this snippet of code, which is difficult to diagnose out of context. It would be helpful to see what is in your listbox.

Hi 6StringJazze, thank you for your email. Here is the template

When i enter values in the 2 textboxes and press Add, it will show on the listbox and spreadsheet. Now when i make a selection from the listbox and click delete, it deletes one by one, meaning it would delete the number first and then i would have to click on delete again to delete the name.

Try this code. Your code only deletes a single cell. I added the EntireRow method.

I also suggest that when building a form, you change the default names of the controls. There is nothing in your code to indicate that CommandButton4 is the Delete button, so I added a comment. But you can name the button something like ButtonDelete. Even if nobody else ever reads your code, your future self will thank you if you ever have to modify the code.

Please Login or Register  to view this content.

Thanks 6StringJazzer, i tried this but i dont want to delete the data in other columns (A,B,C,D,E,F) . This code you provided deletes the entirerow including data that i have in other columns

Thanks Norie, that works good but how come when i have 2 row with equal value, it deletes them both and sometimes it deletes others aswell. I mean when i have this data

G H
2 2
2 2
1 1
4 4
1 2


now if i select the 2nd row to delete, it would delete the 1st row aswell. When i select the last row it would delete the last + the 2 above

Thanks Norie