excel设置下拉菜单多选_如何设置多选Excel下拉菜单

excel设置下拉菜单多选

[Latest update: July 27, 2016] With a bit of Excel VBA programming, you can change an Excel data validation drop down list, so it allows multiple selections. This post is a roundup of articles on how to set up multiple selection Excel drop down lists.

[最新更新：2016年7月27日]借助Excel VBA编程，您可以更改Excel数据验证下拉列表，因此可以进行多个选择。 这篇文章是有关如何设置多选Excel下拉列表的文章摘要。

多选下拉菜单 (Multiple Selection Drop Downs)

You can find a sample file and instructions, in a blog post that I wrote a couple of years ago – Select Multiple Items from Excel Data Validation List.

您可以在几年前写的博客文章中找到示例文件和说明- 从Excel数据验证列表中选择多个项目 。

There is a video in that post, that shows how the multiple selection options work, and a peek at the code that makes the multiple selections possible.

该帖子中有一个视频，显示了多个选择选项的工作方式，并介绍了使多个选择成为可能的代码。