I have a workbook with a few data validation drop down boxes (based on named ranges and using indirect function in a few of them). I am trying to add an option to "Select All" in some of the drop down boxes rather than only having the option to select one at a time.
Any help is appreciated. I have attached a sample workbook. Thanks!DropDownSelectAll.xlsx
Hi,
The data validation functionality only records one value in a cell. If you are using the validation as a criteria for some filtering functionality then what I usually do is include an item 'All' in the list of validation options, then in the criteria cell which would normally link directly to the validation cell enter
=IF(validation_cell_ref="All","*",validation_cell_ref)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Here is the thing, I need an option to select all for 3 of 4 of the rows (in the sample workbook I shared). I do not want the "All" option for the first filter (Region), but because I am using =indirect on the next three filters I don't see a way to work around this.
Create a name for "ALL" and define it as a single cell that has all the values in it that you want to show. Use the Indirect function that you are used to [ =indirect(ALL) ] and the contents of ALL will be dumped into the single cell. I don't know how you want to use this but that is one way of accomplishing your goal.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks