Hi,

I want to highlight the search results of some words in Excel by using VB. Could anybody give some ideas or examples?

Thanks in advance.
Haiying

You will only be able to apply formatting to the entire contents of a cell. (It sounds like you want to highlight some of the contents of a given cell, but not other parts of that same cell.)

I see. Thank you very much.

Actually there is a crude way you can "highlight" specific contents of a cell by changing the font attributes. Let's say you have selected the cell in which the text you want to "highlight" resides and you know the text start offset (intStart) in the cell and its length (intlength) then the following code should change that text's font attributes to "highlight" it

  With ActiveCell.Characters(Start:=intStart, Length:=intLength).Font
    .FontStyle = "Bold Italic"
    .Size = 12
  End With

You will probably want to play around with the FontStyle and Size depending on the attributes of the original text in the cell. There may be better solutions than this, but I don't know of any.

Cheers
nic

I just thought after I posted my response that you can also change the font colour and underline it by setting the .ColorIndex and .Underline properties in the same code. If this doesn't highlight your search results then I don't know what will.

Cheers again
nic

Wow! I was wrong. I didn’t think you could format sections of a cell.

But I tried it, and you can. Sorry to steer you wrong Haiying.
Kudos Nic.