如何自定义Excel数据输入表单

I've posted a few versions of the Excel Worksheet Data Entry Form, starting with the original version that Dave Peterson created. Thanks for your comments and suggestions, which give me ideas for enhancing it.

我已经发布了一些版本的Excel工作表数据输入表单 ，从Dave Peterson创建的原始版本开始。 感谢您的意见和建议，这些意见和建议为我提供了增强意见。

Excel数据输入表 (Excel Data Entry Form)

Here is a screen shot of the worksheet data entry form.

这是工作表数据输入表单的屏幕截图。

自定义数据输入表单 (Customize the Data Entry Form)

If you download the sample file, you'll probably want to customize the data entry form, to suit your data. There are instructions on the Contextures website now, that explain how to change the fields, and add new fields.

如果下载示例文件，则可能需要自定义数据输入表单来适合您的数据。 现在，Contextures网站上有说明，说明了如何更改字段以及添加新字段。

获取工作表数据输入表单 (Get the Worksheet Data Entry Form)

The zipped sample workbook can be downloaded from the Date Entry and Update form page on my Contextures site.

可以从我的Contextures网站上的“ 日期输入和更新”表单页面下载压缩的示例工作簿。

There are several versions of the worksheet data entry form, available for download. Check the descriptions, and get the files that most closely match your requirements.

有几种版本的工作表数据输入表单，可以下载。 检查描述，并获取最符合您要求的文件。

观看自定义数据输入表单视频 (Watch the Customize the Data Entry Form Video)

To see the steps for customizing the data entry form, watch this short Excel video tutorial.

要查看自定义数据输入表单的步骤，请观看此简短的Excel视频教程。

演示地址

_____

_____

翻译自: https://contexturesblog.com/archives/2010/12/10/how-to-customize-the-excel-data-entry-form/