excel数据表单_使用Excel数据输入表单删除订单

excel数据表单

Long ago, Dave Peterson created an Excel worksheet data entry form, so you could enter records on one sheet, and store the data on another sheet. Then, you can hide the data entry sheet, so users don't accidentally change any of the old records.

很久以前，Dave Peterson创建了一个Excel工作表数据输入表单 ，因此您可以在一个工作表上输入记录，并将数据存储在另一个工作表上。 然后，您可以隐藏数据输入表，这样用户就不会意外更改任何旧记录。

There have been a few version of the data entry form file, including the the previous version, in which you could also update the selected record. This way, the data sheet can still be hidden, but users can make changes to the existing records.

数据输入表单文件有几个版本，包括以前的版本，您还可以在其中更新所选的记录 。 这样，数据表仍然可以隐藏，但是用户可以更改现有记录。

删除当前记录 (Delete the Current Record)

In a comment, Bryan asked for a Delete button too. In this new version, that feature is added. (Thanks, Bryan, for the suggestion!) Use this version if you really trust your workbook users – and keep good backup files!

在评论中，Bryan也要求删除按钮。 在此新版本中，添加了该功能。 (感谢Bryan的建议！)如果您真正信任工作簿用户，请使用此版本-并保留良好的备份文件！

When you click the Delete button, a message appears, asking you to confirm that you want to delete the record.

当您单击删除按钮时，会出现一条消息，要求您确认要删除记录。

If you click No, the deletion is cancelled.

如果单击“否”，则删除被取消。

If you click Yes, the record is deleted from the database worksheet, and the data entry cells are cleared.

如果单击是，该记录将从数据库工作表中删除，并清除数据输入单元格。

下载工作表数据输入表 (Download the Worksheet Data Entry Form)

To see how the data entry form works, you can go to my Cotextures website, and download the Worksheet Data Entry Form sample file.

要查看数据输入表单如何工作，您可以访问我的Cotextures网站，并下载工作表数据输入表单示例文件 。

The file is in Excel 2003 format, and is zipped. After you unzip the file and open it, enable macros, so you can use the worksheet buttons. _____________

该文件为Excel 2003格式，并且已压缩。 解压缩文件并将其打开后，启用宏，以便可以使用工作表按钮。 ______________

翻译自: https://contexturesblog.com/archives/2011/09/07/delete-orders-with-excel-data-entry-form/

excel数据表单