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.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
How to get a date verification on a drop down list
0
Answers
0
This may be best answered if you could submit an example AND show how you would like the results to appear.
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 SubHit Alt + F11 and double click the worksheet where you want this to work and then paste the code.