Dim strSelChange As String '提取活动单元格原始值
Dim strRange As String '指定列的某一单元格
Private Sub Worksheet_Change(ByVal Target As Range)
Dim index As Integer '列的范围
Dim strRV As String '提取活动单元格改变值
strRange = ""
strRV = Target
For index = 1 To 100
strRange = "E" + CStr(index) 'E是第五列
srtIndex = CStr(index) + ":" + CStr(index)
If (Range(strRange).Value = strRV) Then
If (Range(strRange).Value <> strSelChange) Then
Rows(srtIndex).Select
End If
End If
Next
strRange = ""
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
strSelChange = ""
If (strRange <> "") Then
With Selection.Interior
.ColorIndex = 3 '红色
.Pattern = xlSolid
End With
Else: strSelChange = Target
End If
End Sub
这是我前两天帮一人写的,看看有不明白的吗?