表单生成excel
There's been an update to my Excel Search Form Builder (SFB), so download the latest version if you've bought this product before. In version 4.08 you can create a form with either 2 or 4 search boxes. Previously, there were only 2.
我的Excel搜索表单生成器(SFB)已有更新,因此,如果您以前购买过此产品,请下载最新版本。 在版本4.08中,您可以创建带有2个或4个搜索框的表单。 以前只有2个。
Note: If you don't have the Search Form Builder yet, it's in the UserForms for Data Entry kit.
注意 :如果您还没有Search Form Builder,它在UserForms for Data Entry工具包中 。
视频:搜索表单生成器演示 (Video: Search Form Builder Demo)
This short video shows the Search Form Builder's 3 easy steps.
这段简短的视频展示了搜索表单生成器的3个简单步骤。
- It lists all fields from your Excel table 它列出了Excel表中的所有字段
- You choose fields for the unique ID and Search Boxes 您选择唯一ID和搜索框的字段
- It builds the Search Form 它建立了搜索表单
0.准备步骤 (0. Preparation Steps)
Before using the SFB, you need to do a few things:
在使用SFB之前,您需要做一些事情:
- Save your workbook as macro enabled 将您的工作簿另存为启用宏
- Format your list as a named Excel table 将列表格式化为命名的Excel表
- Create named ranges as the source for any data validation drop down lists in the table 创建命名范围作为表中任何数据验证下拉列表的来源
1.建立栏位清单 (1. Build a Field List)
After the preparation steps are done, select any cell in your named Excel table.
准备步骤完成后,在命名的Excel表中选择任何单元格。
Then, choose step 2 in the SFB menu.
然后,在SFB菜单中选择步骤2。
2.自定义字段列表 (2. Customize the Field List)
The SFB adds a new sheet to your workbook, with the field list, and instructions and settings on the right side of the sheet.
SFB将新的工作表添加到工作簿中,并在工作表的右侧显示字段列表以及说明和设置。
There's a new setting in this version -- the number of search boxes.
此版本中有一个新设置-搜索框的数量。
- Choose 2 or 4 from the drop down list. 从下拉列表中选择2或4。
选择ID和搜索框字段 (Choose ID and Search Box Fields)
Next, choose the fields that you want in the search form.
接下来,在搜索表单中选择所需的字段。
You MUST select 1 field as the UniqueID field
您必须选择1个字段作为UniqueID字段
You MAY select 1-4 fields for the Search Boxes (based on your "Search Boxes" number)
您可以为搜索框选择1-4个字段(基于您的“搜索框”编号)
3.建立搜寻表格 (3. Build the Search Form)
When the field list is ready, go back to the SFB menu, and run step 3.
字段列表准备好后,请返回SFB菜单并运行步骤3。
- The Search Form is built 搜索表单已建立
- A new sheet is added to your workbook 新工作表已添加到您的工作簿中
- A button on that sheet open the Search Form 该工作表上的一个按钮打开“搜索表单”
使用搜索表 (Use the Search Form)
You can enter search criteria in one or more of the boxes at the top of the form, or leave them empty.
您可以在表单顶部的一个或多个框中输入搜索条件,或将其保留为空。
Then, click the Search button, to see the records that match your criteria. If no criteria were entered, the list will show all the records in your Excel table
然后,单击“搜索”按钮,以查看符合您条件的记录。 如果未输入任何条件,则列表将显示Excel表中的所有记录
选择一条记录 (Select a Record)
In the list of search results, click on a record that you would like to work with.
在搜索结果列表中,单击要使用的记录。
The details for that record will appear in the text boxes and combo boxes on the form.
该记录的详细信息将出现在窗体的文本框和组合框中。
NOTE: The boxes on on a multi-page control, so click the page buttons to see all the data, if necessary.
注意 :多页控件上的框处于打开状态,因此,如有必要,请单击页面按钮以查看所有数据。
编辑记录 (Edit a Record)
After you select a record, you can:
选择记录后,您可以:
change one or more of the fields in the selected record, then click Update .
更改所选记录中的一个或多个字段,然后单击更新 。
or click Add, to put the revised data in a new record
或点击添加 ,将修改后的数据放入新记录中
or delete the selected record
或删除所选记录
When you're finished, click Close
完成后,单击“ 关闭”。
获取搜索表单生成器加载项 (Get the Search Form Builder Add-in)
If you don't have the Search Form Builder yet, it's in the UserForms for Data Entry kit.
如果您还没有Search Form Builder,它位于UserForms for Data Entry工具包中 。
The kit also has step-by-step videos and written instructions, for building an Excel UserForm from scratch.
该工具包还包含逐步视频和书面说明,用于从头开始构建Excel UserForm。
更多搜索表单生成器帮助 (More Search Form Builder Help)
See more details and tips on the Search Form Builder Help page, on my Contextures site.
在我的Contextures网站上的“搜索表单生成器帮助”页面上查看更多详细信息和提示。
The Search Form Builder is designed to add one search form per workbook. However, if you need another one, there are detailed steps for adding a second Search Form.
搜索表单构建器旨在为每个工作簿添加一个搜索表单。 但是,如果您需要另一个,则有添加第二个“搜索表单”的详细步骤 。
There are also a tips on tweaking the search form code, if you need them.
翻译自: https://contexturesblog.com/archives/2020/06/25/excel-search-form-builder-update-2020-06/
表单生成excel