如何在excel中突出显示所选文本 [英] How to highlight selected text within excel

问题描述

我想编写一个VBA函数来突出显示一个excel单元格中的特定文本。这可能吗？我一直在谷歌搜索，但目前还不清楚。

I would like to write a VBA function to highlight specific text within an excel cell. Is this possible? I've been googling but it's unclear at this point.

要澄清，我想在特定列中搜索一个文本值（实际上是一个值列表），并以黄色突出显示匹配的文本。

to clarify, I would like to search a specific column for a text value (actually a list of values) and highlight the matched text in say yellow.

注意：这是我最后做的：

Note: this is what I ended up doing:

  Sub Colors()


    Dim searchString As String
    Dim targetString As String
    Dim startPos As Integer

    searchString = "abc"
    targetString = Cells(2, 1).Value
    startPos = InStr(targetString, searchString)

    If startPos > 0 Then

        Cells(2, 1).Characters(startPos, Len(searchString)).Font.Color = vbRed

    End If


 End Sub

推荐答案

这是基本原理，我认为自定义这个代码不是你所要求的（因为没有提供任何细节）：

This is the basic principle, I assume that customizing this code is not what you are asking (as no details about this were provided):

 Sub Colors()

 With Range("A1")
    .Value = "Test"
    .Characters(2, 2).Font.Color = vbGreen
 End With

 End Sub

小描述虽然很自信：第一个 2是指需要着色的第一个字符，第二个2是指长度。

Small description although it speaks quite for itself: the first "2" refers to the first character that needs to be colored, the second "2" refers to the length.

这篇关于如何在excel中突出显示所选文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！