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

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

Excel VBA - Problem with Closing Print Preview 0
Excel Concatenate Form Name to Parse for function 1
Access Click in Table to Open Form 0
Shortcut to make a drop-down LOV show during data entry? 1
Data Form does not allow entry in some fields 4
Update multiple record values in form/query 2
data input format 1
Cell reference returning cell name instead of value 1

Top