萌新求助！如何实现某一单元格选择下拉后，右侧单元格记录时间

记录当前的时间，而且不会相互更新。只要左侧单元格选择下拉数值后就自动填入…

学下vba，里面最基础的

vba事件，很简单

右击工作表标签>查看代码>粘贴下面代码可以实现修改a1:a10时在右侧单元格填充当前系统时间.
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Dim rng As Range, c As Range
'判断是否修改a1:a10
Set rng = Application.Intersect(Target, Range("a1:a10"))
If rng Is Nothing Then Exit Sub
Application.EnableEvents = False '关闭触发器
For Each c In rng.Cells
c.Offset(, 1) = Now
Next
Application.EnableEvents = True
End Sub

谢谢楼上大神。刚刚接触vba，好多不懂…😢