February 19, 2021
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.
December 7, 2016
Don’t know if I understand how you want it to work, but I try to give you an answer.
You can set a default value in the cell where you have the data validation list, but as soon you choose another value from the list the default value is overwritten. The default value can of course be set again via VBA code and it seems to me to be your only option.
If you can upload a sample file where you show in more detail what you want and how it should work, you might perhaps get better and more spot on answers.