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

H

harinath

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

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

Rowan

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
 
Top