'If user deletes the dropdown cell's data do nothing 'If an error occurs, enable events and quit the code Private Sub Worksheet_Change(ByVal Target As Range) VBA Code to make multiple selections in a dropdown listĪll you need to do is to copy and paste the following code into your file and change the cell reference of the dropdown. The code should be in the worksheet’s editor containing the dropdown, because the code tracks changes in the cell. This will open the corresponding editor on the right. Double-click on the sheet item on the Project pane to the left.Once the dropdown is ready, press the Alt + F11 keys to open VBA.The rest will be handled with a VBA macro. Start by creating a standard data validation dropdown. In this guide, we're going to show you how to make multiple selections in a dropdown list in Excel. Excel doesn’t have any built-in feature that allows you select multiple items in a dropdown.
0 Comments
Leave a Reply. |