单元格下拉框实现复选框多选
You can use check boxes on a worksheet, and link the results to a cell. If the box is checked, the cell shows TRUE, and if it’s not checked, the cell shows FALSE or the cell is empty. This makes it easy for someone to give a quick answer to a question, or select an option. You can even link check boxes to cells with a macro, so something happens automatically when the box is clicked.
您可以使用工作表上的复选框,并将结果链接到单元格。 如果选中该框,则该单元格显示TRUE,如果未选中,则该单元格显示FALSE或该单元格为空。 这使某人可以轻松地快速回答问题或选择一个选项。 您甚至可以使用宏将复选框链接到单元格,因此单击该复选框时,某些操作会自动发生。
两部分教程 (Two Part Tutorial)
This will be a two part tutorial on how to link check boxes to a macro.
这将是一个分为两部分的教程,介绍如何将复选框链接到宏。
- First, we’ll set up the check boxes, and link them to cells. You’ll see how to do this manually, and with a macro. 首先,我们将设置复选框,并将其链接到单元格。 您将看到如何使用宏手动执行此操作。
- In the next part, we’ll link check boxes to cells with a macro. 在下一部分中,我们将复选框链接到带有宏的单元格。
创建待办事项清单 (Creating a To Do List)
To see how the check boxes can be used, we’ll set up a To Do list, with a check box for each item. Here is the list, ready for the check boxes.
要查看如何使用复选框,我们将设置一个“待办事项”列表,其中每个项目都有一个复选框。 这是清单,准备使用复选框。
插入复选框 (Insert a Check Box)
To insert a check box, follow these steps:
要插入一个复选框,请按照下列步骤操作:
Click the Developer tab on the Ribbon. If you don’t see the Developer tab, follow