I'm trying to write VB to allow selecting a phrase and a range and then
highlighting each instance of the phrase with bold and red font. Want to
highlight only the characters contained in the phrase, not the entire cell's
contents. Having trouble using a command similar to FIND in Excel, which
doesn't seem to translate well to VB. Every reference I've found is for
locating a cell, not a character within a cell.

I'm using RefEdit to select the range and a text box to enter the phrase.
Want to create a UserForm that can be added to the normal template.

Any suggestions?