以下是引用chen_zhh在2006-3-23 22:24:00的发言:
高手谈不上,楼主的忙到是可以帮一下的,请试试如何!
按Alt_F9打开VB编辑器,然后双击sheet1,粘贴以下代码:
Dim flag As Integer
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo exit_sub
R = Target.Row: C = Target.Column
If Target.Value = 0 And flag <> 1 And R >= 5 And R <= 12 Then
flag = 1
C = C - 1
If C = 4 Then C = 12
Cells(R, C) = ""
flag = 0
End If
exit_sub:
End Sub
欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/) | Powered by Discuz! X3.3 |