下面这个代码只能让B(2)列的值变色,怎么改成从2到10列里的值都可以变化
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Err
If Target.Column = 2 Then
If UCase(Target.Value) = "1" Then
Target.Interior.Color = vbRed
ElseIf UCase(Target.Value) = "2" Then
Target.Interior.Color = vbBlue
End If
End If
Exit Sub
Err:
End Sub
1、我知道Target.Column = 2 Then 是特定或指定第二列里的值,怎么改成多列的
2、在If UCase(Target.Value) = "1" Then
Target.Interior.Color = vbRed
这里的1,怎么改成让1、2、3、13、14,等都可以变色,就是把单一的条件变多
第1个回答 2017-03-25
If Target.Column = 2 Then
If UCase(Target.Value) = "1" Then
Target.Interior.Color = vbRed
ElseIf UCase(Target.Value) = "2" Then
Target.Interior.Color = vbBlue
End If
End If
复制8份就可以了。target.column = 2 到 10 判断
If UCase(Target.Value) = "1" Then
Target.Interior.Color = vbRed
ElseIf UCase(Target.Value) = "2" Then
Target.Interior.Color = vbBlue
End If
End If
复制8份就可以了。target.column = 2 到 10 判断
第2个回答 2017-03-25
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Err
If Target.Column >= 2 And Target.Column <= 10 Then
Select Case UCase(Target.Value)
Case "1"
Target.Interior.Color = vbRed
Case "2"
Target.Interior.Color = vbBlue
Case "3"
Target.Interior.Color = vbYellow
Case "13"
Target.Interior.Color = vbYellow '根据需要修改为其它值
End Select
End If
Exit Sub
Err:
End Sub本回答被提问者采纳
On Error GoTo Err
If Target.Column >= 2 And Target.Column <= 10 Then
Select Case UCase(Target.Value)
Case "1"
Target.Interior.Color = vbRed
Case "2"
Target.Interior.Color = vbBlue
Case "3"
Target.Interior.Color = vbYellow
Case "13"
Target.Interior.Color = vbYellow '根据需要修改为其它值
End Select
End If
Exit Sub
Err:
End Sub本回答被提问者采纳