VB codes for delete command button

Will any expert pl help me on the following?

I searched the entire website and found an example where by data can be entered into the excel sheets using the user forms. But all the user forms have only the "Ok", "Clear" and "Cancel" buttons. I want to delete a row of data in the excel sheet that has been entered using the user form. This deletion should be done only through a command button "delete". How do I do this? What are the codes for that?

Also I want to have codes for "Previous", "Next", "First" and "Last" command buttons.

Looking forward to your reply at the earliest.

Lilly

i don't think i am understanding your problem properly because when i create a userform it allows me to choose what controls are on there and you can write the code specific to that button. i have played around for a few seconds and could probably write you some code that would delete a number of cells? i think i would use activecell.value = "" iteratively although i am sure there are cleverer more succinct ways of doing this. don't think i am understanding the problem though! i am not an expert so you may need some who is!!!

Hi Lilly,

I'm afraid there's not a generic solution to this (like copy&paste this bit of code, and everything will work). Someone will help you, but you should be more specific with your desires, and you should post an example of your workbook. It will help, greatly.