CLear Data Entry Form Fields

T

Tony

I have a worksheet that I have created a data entry form. When I copy the
data to the worksheet, I want to clear the data entry fields.

The first field is called: RecordNo

What code can I use for this?
 
O

Otto Moehrbach

Tony
One way is to name the range of all the data entry cells (the cells you
want cleared), say, "DataEntryCells". The code to clear these cells is
then:
Range("DataEntryCells").ClearContents
HTH Otto
 
T

Tony

will this work for fields in a data entry form?

Otto Moehrbach said:
Tony
One way is to name the range of all the data entry cells (the cells you
want cleared), say, "DataEntryCells". The code to clear these cells is
then:
Range("DataEntryCells").ClearContents
HTH Otto
Click to expand...
 
Top