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 - 27 Sep 2007 10:19 GMT
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