A couple of years ago, I described how you could select multiple items from an Excel drop down list. One of my clients needed that feature in a workbook last week, so I've made an enhancement to the VBA code. Now you can edit multiple selections in Excel after entering them.
几年前,我描述了如何从Excel下拉列表中选择多个项目 。 我的一位客户上周在工作簿中需要此功能,因此我对VBA代码进行了增强。 现在,您可以在输入多个选择后在Excel中对其进行编辑。
编辑问题 (Problems With Editing)
In the previous version, you could select multiple items, as promised, with no problems. However, if you tried to edit the cell, you might have seen the data validation error alert.
在以前的版本中,您可以选择多个项目,没有问题。 但是,如果您尝试编辑单元格,则可能已经看到数据验证错误警报 。
To prevent that error alert from appearing, you can turn off the setting.
为防止出现该错误警报,您可以关闭该设置。
However, the helpful VBA code simply added your revised text, to the existing text. That's probably not the result that you wanted!
但是,有用的VBA代码只是将您的修订文本添加到现有文本中。 那可能不是您想要的结果!
添加编辑复选框 (Add an Editing Check Box)
In the new version, there is a check box on the workshe