excel调用用户窗体_创建一个Excel用户窗体

excel调用用户窗体

This week, I've been working on a client's Excel file, and we're using a UserForm for data entry, instead of worksheet cells.

本周，我一直在处理客户的Excel文件，并且我们使用UserForm代替工作表单元格进行数据输入。

Data can be entered in the UserForm, and stored in a worksheet, when the form is closed. The UserForm could open automatically when the file opens, or put a button on the worksheet, and click that to open the form.

当表单关闭时，可以在用户窗体中输入数据并将其存储在工作表中。 当文件打开时，UserForm可能会自动打开，或者在工作表上放置一个按钮，然后单击以打开表单。

On the Contextures website, you can find instructions and sample workbooks, for creating a simple UserForm, or a UserForm with drop down lists.

在Contextures网站上，您可以找到用于创建简单UserForm或带下拉列表的UserForm的说明和示例工作簿。

观看Excel UserForm视频 (Watch the Excel UserForm Videos)

To see the steps for creating an Excel UserForm, you can watch this 3-part Excel Video Tutorial series. You'll see how to add a UserForm to your Excel file, then put text boxes and buttons on the form.

要查看创建Excel UserForm的步骤，可以观看此分为3部分的Excel Video Tutorial系列。 您将看到如何将UserForm添加到Excel文件，然后在表单上放置文本框和按钮。

Part 1

第1部分

演示地址

Part 2

第2部分

演示地址

Part 3

第三部分

演示地址

Combo Box Lists

组合框列表

演示地址

翻译自: https://contexturesblog.com/archives/2012/03/29/create-an-excel-userform/

excel调用用户窗体