[VBA] Change Selection – Update Drop Down List in Excel
This does not require any special code.
It can be done just by changing the value in the particular cell that has a validation list.
Here is an example VBA code that changes the selection in a drop down validation list.
'Considering cell A1 has a validation of these Values
'List Value1
'List Value2
'List Value3
'Here is how to change the selection
Thisworkbook.Range("A1") = "List Value2"
We have added values to list, changed the selection.
If it has to be done manually, then just type any value available in the validation list. If You enter a value that is not in the list, Excel will throw an error & will not allow data entry.
That is the whole purpose of a Data validation drop down list. i.e., allowing only valid predefined entries.
