detecting word "private"

[bob323]

Thanks for all the help so far everyone the first part worked out really well!

I have another rich text box that you can type directly into, I want it to detect whenever the word "private" is entered, change the font color of "private" to blue and return the cursor to its original place and font color.

The coding yesterday really helped, but I could't make it work very well for situations where the user is typing. Any additional help here would be really appreciated!!

[Lee M.]

I am not sure if this will help but you can apply a variable to the
contents of the text box. Then see if the variable = "Private"...or use the instr function.

if strName = "Private" then
txtBox.forecolor = vbRed
end if

You may want to add the vbPropercase, because the text box will be case sensitive. private <> Private etc.
I hope this helps!
Lee