Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Form does not allow entry in some fields | Excel Discussion (Misc queries) | |||
Data Entry Form | Excel Discussion (Misc queries) | |||
Can I use a FORM to enter data if I have more than the 32 fields? | Excel Discussion (Misc queries) | |||
Data Entry Form | Excel Worksheet Functions | |||
data entry form | Excel Discussion (Misc queries) |