excel数据表单_新的改进的Excel数据输入表单

excel数据表单

Many moons ago, Dave Peterson created a sample Excel worksheet data entry form and kindly shared it on the Contextures website. In Dave's original form, users could add records on the data entry sheet, and click a button to go to the database sheet, where they could review or edit the order records.

许多月前，Dave Peterson创建了一个示例Excel工作表数据输入表单，并在Contextures网站上进行了共享。 在Dave的原始表单中 ，用户可以在数据输入表上添加记录，然后单击按钮以转到数据库表，在数据库表中可以查看或编辑订单记录。

I've created a couple of versions since then, including an Excel data entry form that allowed users to view, add and update records, while staying on the data entry sheet.

从那时起，我创建了几个版本，包括一个Excel数据输入表单，该表格允许用户查看，添加和更新记录 ，同时保留在数据输入表上。

标记所需的单元格 (Mark the Required Cells)

Here's the latest version of the workbook, with new features that were suggested in the comments for the previous version.

这是工作簿的最新版本，具有以前版本的注释中建议的新功能。

The first new feature is the ability to mark which cells are required. In column E, add an X beside the cells that are mandatory, and leave the optional rows blank. Conditional formatting colours the required cells in green, and the optional cells in grey.

第一个新功能是能够标记所需的单元格。 在E列中，在必填单元格旁边添加X，并将可选行保留为空白。 条件格式将所需的单元格涂成绿色，并将可选的单元格涂成灰色。

You can hide columns E and F before using the workbook.

您可以在使用工作簿之前隐藏E和F列。

选择特定记录 (Select a Specific Record)

In the new version, you can select a specific record from the drop down list in cell L3, to view or edit that record. Before using the workbook, hide column M, that has a formula to calculate the record number for the selected order.

在新版本中，您可以从单元格L3的下拉列表中选择特定记录，以查看或编辑该记录。 在使用工作簿之前，隐藏M列，该列具有用于计算所选订单的记录编号的公式。

Or, as in previous versions, you can click the navigation buttons to move forward or back through the records, based on the row numbers in the database.

或者，与以前的版本一样，您可以单击导航按钮以根据数据库中的行号在记录中前进或后退。

下载数据输入表单文件 (Download the Data Entry Form File)

The zipped sample workbook can be downloaded from the Date Entry and Update form page on my Contextures site. On that page, go to the Download section, look for Version 1

可以从我的Contextures网站上的“ 日期输入和更新”表单页面下载压缩的示例工作簿。 在该页面上，转到“ 下载”部分 ， 查找“版本1”。

After you open the workbook, enable macros, so the buttons and event code will work correctly.

打开工作簿后，启用宏，以便按钮和事件代码将正常工作。

There is an instruction sheet in the workbook, that describes how to navigate, add and update records, and maintain or modify the named ranges. ___________

工作簿中有一个说明表，描述了如何导航，添加和更新记录以及维护或修改命名范围。 ___________

翻译自: https://contexturesblog.com/archives/2010/10/01/new-improved-excel-data-entry-form/

excel数据表单