excel数据表单_Excel中的工作表数据输入表单

excel数据表单

With a bit of programming, you can make it easy for users to enter data in an Excel workbook, and keep them away from the stored data. Dave Peterson created a sample workbook with a worksheet data entry form.

通过一些编程，您可以使用户轻松地在Excel工作簿中输入数据，并使他们远离已存储的数据。 Dave Peterson用工作表数据输入表单创建了一个示例工作簿。

There are data validation drop down lists in cells D5 and D7, and quantity is typed in cell D9.

在单元格D5和D7中有数据验证下拉列表，在单元格D9中键入了数量。

Click the Add to Database button, and the new record is added at the end of the database, which is a list on a different sheet.

单击添加到数据库按钮，新记录将添加到数据库的末尾，这是另一张工作表上的列表。

查看存储的记录 (View the Stored Records)

In Dave's workbook, you could click the View Database button to go to the database sheet, and review or edit the order records.

在Dave的工作簿中，您可以单击“查看数据库”按钮转到数据库表，然后查看或编辑订单记录。

In some cases you might prefer to hide the database sheet, to protect the records, but still allow users to view the existing data. I've added a few buttons to Dave's workbook, to allow users to scroll through the existing records.

在某些情况下，您可能希望隐藏数据库表以保护记录，但仍然允许用户查看现有数据。 我在Dave的工作簿中添加了一些按钮，以允许用户滚动浏览现有记录。

The navigation buttons take you to the first, previous, next or last record, or you can type a record number in the yellow cell, to go to a specific record.

导航按钮可将您带到第一条记录，上一条记录，下一条记录或最后一条记录，或者您可以在黄色单元格中键入记录编号以转到特定记录。

The Go To Database button is still on the worksheet, but you could remove that, and hide the PartsData sheet, so users are less likely to change the data.

“转到数据库”按钮仍在工作表上，但是您可以将其删除，然后隐藏PartsData工作表，因此用户更改数据的可能性较小。

下载样本文件 (Download the Sample File)

The zipped sample workbook can be downloaded from the Data Entry Worksheet Form page on my website.

可以从我网站上的“ 数据输入工作表表单”页面下载压缩后的示例工作簿。

In the Download section, look for Version 2 - Navigation Arrows.

在“ 下载”部分中 ，查找“ 版本2-导航箭头” 。

工作表数据输入表单上的更多文章 (More Articles on the Worksheet Data Entry Forms)

New Improved Excel Data Entry Form How to Customize the Excel Data Entry Form Delete Orders with Excel Data Entry Form Check Excel Database Before Adding New Item ___________________________

新的改进的Excel数据输入表单 如何自定义Excel数据输入表单使用Excel数据输入表单 删除订单 在添加新项目之前检查Excel数据库 ___________________________

翻译自: https://contexturesblog.com/archives/2009/04/09/worksheet-data-entry-form-in-excel/

excel数据表单