Hi Team,
Can you please help me in writing vba code to make partial selected text as red in the same cell. I am not looking for a text box search string option
This code works good in making the complete text as red in a cell but not partial .
1. I need to select text
2. Run Vba code
3. convert font color of the selected text as red.
Any help from the team ll be greatly appreciated.
Can you please help me in writing vba code to make partial selected text as red in the same cell. I am not looking for a text box search string option
VBA Code:
Selection.Font.Color = vbRed
This code works good in making the complete text as red in a cell but not partial .
1. I need to select text
2. Run Vba code
3. convert font color of the selected text as red.
Any help from the team ll be greatly appreciated.