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

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.

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

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.

--
Regards,
Tom Ogilvy


"harinath" wrote in message
...
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.

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

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


--
Regards,
Tom Ogilvy


"harinath" wrote in message
...
But in my case i need make a cell value to default.
In case the user forget to select a value for a cell which has list
validation.

can you give some example

thanks,harinath

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

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