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