Forum Discussion
Showing a default value in a Data Validation List which is built from table with defined named range
Hello
I use a data validation list to select the item i want.
This Data Validation List is built by a table and the items in the table is a defined name so that when i insert an item to the list, this new item is automaticcaly available in the data validation list without adjusting the look-up range.
Now i want that this validation list shows a default value.
Can someone help me with this.
And additional feature that i want if possible is that this default value is always shown also after that this validation is used and and and an item was chosen the previous time.
Thanks in advance
My best regards.
2 Replies
- Yea_SoBronze Contributor
That can only be done using VBA:
https://www.extendoffice.com/documents/excel/3616-excel-data-validation-default-value.html#:~:text=Right%20click%20the%20sheet%20tab%20with%20the%20drop-down,a%20default%20value%20in%20data%20validation%20drop-down%20list
cheers
- Detlef_LewinSilver Contributor
I don't understand your last requirement but the built-in data validation feature has no option for a default value.