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...
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