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 |
Clear data in a FORM row
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 |
All times are GMT +1. The time now is 08:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com