以下是点击单元格I2,则显示当天的日期:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 9 And Target.Row = 2 Then
ActiveCell.Value = Year(Date) & "-" & Month(Date) & "-" & Day(Date)
End If
End Sub
请问:怎么样才能做到,在同一个工作簿的各表中通用(不想每个表都写这样程序)
先谢了!