Clear data in a FORM row

D

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
 
I

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
How do I clear a form? 0
copying to new workbook 0
Clearing Fields in a Word Form 5
Clear contents of last two rows of data on sheet 6
Clear all rows except first two 7
Macro to Combine Data from Multiple Sheets with Cell References 4
Delete rows autofilter range problem 5

Top