第1个回答 2012-04-25
应该是Workbook选择改变时触发,这样不管那个表都能用,楼上“三三万尺”的是只对SHEET1有效,我改的:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
On Error Resume Next
If Target.Interior.Color = vbBlack Then '如果为黑色
Target.Value = 1
Else
If Target.Interior.Color = vbRed Then '如果为红色
Target.Value = 2
End If
End If
End Sub