Using the Data Validation List

[abmark]

Is there a way in using the Data Validation List, a default value show up?


Thanks in advance,
Mark

 

[Smitty]

I suppose you could pre-fill it with an event. E.g.

Private Sub Worksheet_Activate()
    Range("C1") = 1
End Sub

Where C1 houses your DV.

HTH,

 

[Oaktree]

Maybe you'd just fill in the "defaults" before you save the workbook?

(Smitty... we seem to be following each other)

 

[abmark]

Could you please show some detailed code?

Thank you very much,
Mark