help for a highlighter

[lifesayko]

this is one of my first brush ups with VBA(and excel, for that matter), so I don't know much about the language.
nycase, I'm supposed to write a macro that will check the text in a certain cell to see if there are any specific words(which I define), and turn them Red.

I've thought of a way to do this, but I need to be able to define which a place within a cell. ex. if <> is a cell, then <Hello world, how are you today> I would need to say "from space 6 onwards check if...., then from space 13 onwards, check if....." etc.

can anyone explain how to do this? thanks alot.

if you know a good way of making this macro, please tell me that as well ^_~

[RobDog888]

Welcome to the Forums.

So this will only check one cell, correct?

Usually the easiest way to determine how to access something programmatically, you record a macro
doing your task, stop it and check the generated code in the VBA IDE.

Now, since your needing to do some searching in the cell before you do anything, it would be easier to just
record a macro changing the cells backcolor. Then we can use that as astarting place.

[RobDog888]

This should get you started. It highlights the word "World!" in cell C6.

Private Sub HighLightMe()
    'C6 contains "Hello World!" and highlights "World!"
    Dim iStart As Integer
    ActiveSheet.Range("C6").Select
    iStart = InStr(1, ActiveCell.Value, "World!")
    If iStart > 0 Then
        'Turn off coloring for any previous finds
        Selection.Font.ColorIndex = xlAutomatic
        'Turn on coloring for the found word (World!)
        ActiveCell.Characters(Start:=iStart, Length:=iStart + Len("World!")).Font.ColorIndex = 3
    End If
End Sub