How to get a date verification on a drop down list

0

I have a spread sheet with various drop down list. however i would like a date verification to accure when an item in Collum F is changed where the date is then showing in H aswell as for the date to update when the dropdown option is changed in F.

Answer
Discuss

Answers

0

This may be best answered if you could submit an example AND show how you would like the results to appear.

Discuss
0

You could try this macro:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column <> 6 Then Exit Sub

Cells(Target.Row, 8).Value = Now()

End Sub

Hit Alt + F11 and double click the worksheet where you want this to work and then paste the code.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login