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?
|