如何在选定区域内改变指定单词的颜色

lulu800

找到一个可以改变颜色的宏，但是执行范围是整个工作表。想请教各位大神，有没有办法对鼠标当前选中的区域执行呢？

Sub Ss()
Dim c As Range
For Each c In ActiveSheet.UsedRange
  i = 1
  While InStr(i, c, "汽车", 0) > 0
    i0 = InStr(i, c, "汽车", 0)
    If i0 > 0 Then c.Characters(i0, 4).Font.Color = vbRed: i = i0 + 2
    Wend
  Next
End Sub

lulu800

求大神拯救

lele6809

那就先选择，在按钮执行，改一个地方
For Each c In Selection

Datous

lulu800 发表于 2019-3-21 17:36
求大神拯救

1. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   
2. Dim L As Integer, T As Range
   
3. Application.EnableEvents = False
   
4. For Each T In Target
   
5.     L = 1
   
6.     While InStr(L, T.Value, "汽车")
   
7.         L = InStr(L, T.Value, "汽车")
   
8.         T.Characters(L, 2).Font.ColorIndex = 3
   
9.         L = L + 2
   
10.     Wend
    
11. Next
    
12. Application.EnableEvents = True
    
13. End Sub

复制代码

yuygog

1. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   
2. On Error Resume Next
   
3. If Not Application.Intersect(Target, ActiveSheet.UsedRange) Is Nothing Then
   
4.     Dim matches, match
   
5.     With CreateObject("VBSCRIPT.REGEXP")
   
6.     .Pattern = "汽车"
   
7.     .Global = True
   
8.         If .test(Target.Value) Then
   
9.         Set matches = .Execute(Target.Value)
   
10.         For Each match In matches
    
11.             With Target.Characters(Start:=match.firstindex + 1, Length:=match.Length) '
    
12.             .Font.ColorIndex = 3
    
13.             End With
    
14.         Next match
    
15.         End If
    
16.     End With
    
17. End If
    
18. End Sub

复制代码

lulu800

感谢大神的帮助！完美解决了我的问题！