Clear data in a FORM row

[Dave]

Clear data in a FORM row

I have 20 rows of data entry on an Excel FORM.
There is a delete button next to each row that I want to program to "clear"
the row on the FORM
(I have code on other buttons to save to the appropriate "Sheets")
So I just need to know how to clear the form.

More elegant if it is easily doable:
When the delete button clears a ROW (could be any of the 20 rows) it would
be nice to "pull up" all lower rows so there is not a blank row.

Any help here will be appreciated.

Thanks in advance

Dave

 

[Incidental]

Hi Dave

Your post is a little unclear to me, are you using a Userform? if so
what type of control are you using that contains the rows? is it a
listbox or textbox etc? it should not be to hard to clear a row but i
would need to know what control you are using.

S