CLear Data Entry Form Fields
 

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?

CLear Data Entry Form Fields
 

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
"Tony" wrote in message
...
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?

CLear Data Entry Form Fields
 

will this work for fields in a data entry form?

"Otto Moehrbach" wrote:

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
"Tony" wrote in message
...
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?