|
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 14 Then Exit Sub
Cells(Target.Row, 15).Value = WorksheetFunction.Text(Now(), "h:m")
End Sub
这个宏是当在14列输入的时候15列会自动填上当前时间,但是我想实现当1列输入时11列也自动填当前时间,两个功能同时时间,如何将两个宏合起来。
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim r&, c&, t$
-
- r = Target.Row
- c = Target.Column
- t = WorksheetFunction.Text(Now(), "h:m")
-
- If c = 1 Then Cells(r, 11).Value = t
- If c = 14 Then Cells(r, 15).Value = t
- End Sub
复制代码
|
|