View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave[_9_] Dave[_9_] is offline
external usenet poster
 
Posts: 12
Default Clear data in a FORM row

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