VBA code: drop down list with multiple selections Private Sub Worksheet_Change(ByVal Target As Range) In the Microsoft Visual Basic for Applications window, copy the below VBA code into the code window. Open the worksheet you have set data validation drop-down list, right click on the sheet tab and select View Code from the context menu.Ģ. You can apply the below VBA code to make multiple selections from the drop-down list in a worksheet in Excel.
How to make multiple selections from the drop-down list as below screenshot shown? The methods in this article can help you solve the problem.Ĭreate drop down list with multiple selections with VBA codeĮasily create drop down list with multiple selections with an amazing tool How to create drop down list with multiple selections or values in Excel?īy default, you can only select one item per time from a data validation drop-down list in Excel.
0 kommentar(er)
