Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change format of single word in cell
Hi,
I need to search and highlight (using bold, change color or whatever single words in Excel using VBA. With find method, I can find them, bu when using the replace method, always the complete cell, in which th word has been found, will be highlight. Any idea?? Thanks and regards, Zeno -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change format of single word in cell
Zenon,
You need to use the characters method once you've found the word: Dim myStr As String ActiveCell.Value = "This word is bold and red." myStr = "word" With ActiveCell.Characters(Start:=InStr(1, ActiveCell.Value, myStr), _ Length:=Len(myStr)).Font .FontStyle = "Bold" .ColorIndex = 3 End With As for integrating this into your code, we would need to see your code to do that.... HTH, Bernie MS Excel MVP "Zenon " wrote in message ... Hi, I need to search and highlight (using bold, change color or whatever) single words in Excel using VBA. With find method, I can find them, but when using the replace method, always the complete cell, in which the word has been found, will be highlight. Any idea?? Thanks and regards, Zenon --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change format for an individual word in a cell | Excel Discussion (Misc queries) | |||
Add Word and change format | Excel Discussion (Misc queries) | |||
How can I copy a list from word into a single cell in excel | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Conditional format (word change) | Excel Worksheet Functions |