Forum Discussion
Macro to select multiple values in Data Validation List
Hello everyone, I have this VBA code
Private Sub Worksheet_Change(ByVal Target As Range) Dim OldValue As String Dim NewValue As String Application.EnableEvents = True On Error GoTo Exitsub ...
If you're willing to use an add-in, you can try a free Excel add-in called "Search deList". You can find it here:
Search deList
This new version has some additional features, some of them:
- Several ways to search, like using AND or OR or LIKE operator , with or without keyword order.
- Sort the list by original order or ascending order.
- Widen or shorten the combobox width at run time.
- Insert multiple entries into the cell.
