Excel and VBA help please

[paul_bam]

Hello everyone,

First things first. This is my first post, so a big hello to everyone.

Now on to my problem. I have developed an Excel spreadsheet that has a form. The form was developed using VBA . The form is very simple and has one combo box and two command buttons on it. The combo box get populated from column A of sheet 1 and I achieved this by using the Rowsource from within the properties of the combo box. One of the command buttons is named cancel and I have got this to work fine. However, and this is where I require some help, the other command button is named "Delete" and what I would like it to do is this, whichever value that is selected from the combo box list, then when the user clicks on delete then it would find that value in column A, then select the entire row and finally delete the row.

Any help will be very much appreciated.

Thanks in advance

Paul

 

[paul_bam]

Ditto!!

We'll always help folk out for free, in our spare time, but there's a limit...........

And, just for future reference, please enlighten me as to what your actual limit is? I wouldn't want to think I was encroaching or anything.