excel下拉菜单vba_在Excel下拉菜单中删除使用过的项目

excel下拉菜单vba

There is a new sample file on my Contextures web site, which lets you pick players for each inning in a baseball game. You could tweak the file a bit, and use it to assign employees to workstations each day of the week, or anything similar. After assigning employees, remove used items in Excel drop down list, to prevent them from being assigned twice.

我的Contextures网站上有一个新的示例文件，可让您为棒球比赛中的每一局选择球员。 您可以稍微调整文件，然后使用它在一周中的每一天或类似的时间将员工分配到工作站。 分配员工后，请在Excel下拉列表中删除使用过的项目，以防止它们被分配两次。

名称从列表中消失 (Names Disappear From List)

Once you have assigned a player in an inning, that name disappears from the drop down list in that column. In the screen shot below, Mike has been assigned as the pitcher for inning one. When I open the list in the cell below, Mike’s name is missing – it used to be between Lee and Pat.

在局中分配了一名球员后，该名称将从该列的下拉列表中消失。 在下面的屏幕截图中，麦克已被指定为一局投手。 当我在下面的单元格中打开列表时，Mike的名字丢失了–以前在Lee和Pat之间。

查看球员姓名分配 (See the Assignments by Player Name)

There was an older version of this sample file, and I have updated it to use Excel Tables. I’ve also added a sheet that shows the assignments by player name, and you can see how often each player was assigned to a position.

该示例文件有一个较旧的版本，我已经对其进行了更新，以使用Excel Tables。 我还添加了一张表格，该表格按球员姓名显示分配情况，您可以看到每个球员分配到位置的频率。

下载档案 (Download the File)

To see the file, and how it works, you can download it from my Contextures website. On the Excel Samples page, look for DV0061 - Assign Players Each Inning. The file is in xlsx format, and does not contain macros.

若要查看文件及其工作方式，可以从我的Contextures网站下载它。 在“ Excel样本”页面上，查找DV0061-每个局限分配球员 。 该文件为xlsx格式，不包含宏。

翻译自: https://contexturesblog.com/archives/2013/12/17/remove-used-items-in-excel-drop-down/

excel下拉菜单vba