how to set default value in list validation" did not return results.

[Guest]

how to set default value in list validation for a cell

Ex: a list validation with values 2,3,4,5.. in a cell
In this 3 should be default value when u open the file for the particular cell

Please put some light on this.

 

[Tom Ogilvy]

the default selection in a validation dropdown is the current value of the
cell if there is a match. Otherwise nothing will be shown as selected.

 

[Tom Ogilvy]

if isempty(Range("B9").Value) then
Range("B9").Value = 21
End if

 

[Guest]

If you know the what you want the default value to be and it is valid based on the validation list you could set it on opening the file. Use the ThisWorkbook Code window to enter

Private Sub Workbook_Open(
Sheets("Sheet1").Range("A1").Value = 3
End Su