| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to highlight (bold,red) selected text within range
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using text for the range in AVERAGE function | Excel Worksheet Functions | |||
| lose selected range when I right click | Setting up and Configuration of Excel | |||
| lose selected range when I right click | Excel Discussion (Misc queries) | |||
| lose selected range when I right click | Excel Worksheet Functions | |||
| File Save As -Selected Range | Excel Discussion (Misc queries) | |||
Hybrid Mode
