<p>这样<br/><br/>rivate Sub Worksheet_Change(ByVal Target As Range)<br/><br/>Dim x As Integer<br/>Dim y As Integer<br/><br/>x = Target.Row<br/>y = Target.Column<br/><br/>If y = 1 And Cells(x, 1).Value <> "" Then<br/> Cells(x, 2) = Date<br/>End If<br/><br/>End Sub<br/></p>
[此贴子已经被作者于2008-3-6 0:20:34编辑过] |