Akuini
Well-known Member
- Joined
- Feb 1, 2016
- Messages
- 5,089
- Office Version
- 365
- Platform
- Windows
Akuini submitted a new Excel article:
Macro to create searchable data validation+combobox - Speed up searching in long list data validation & easy to set various specific behaviors
Read more about this Excel article...
Macro to create searchable data validation+combobox - Speed up searching in long list data validation & easy to set various specific behaviors
Excel doesn't provide a built-in way to search data validation list. So it could be hard to scroll through the list when the list is long. This searchable data validation+combobox is a way to deal with that problem. It has these behavior:
1. The combobox can appear and hide by certain action e.g double-clicking a cell.
2. You can type some keywords in the combobox and the list will be narrowed down as you type.
3. You only need 1 combobox for all cells with data validation.
I've answered...
Read more about this Excel article...