Hello.. my need is to automate coloring of selected text in a text box shape in xl.
But the first step to get the selected text or the starting position of the cursor in the text box shape itself seems difficult.
( I am not using Active X text box just a normal text box )
Though it seems to be possible to color the text with the mention of starting position and length,
using code line
With Selection.Characters(Start:=10, Length:=9).Font.colorindex = vbred
what I need to is to color the user-selected text, which is a variable.
Thanks in advance.
But the first step to get the selected text or the starting position of the cursor in the text box shape itself seems difficult.
( I am not using Active X text box just a normal text box )
Though it seems to be possible to color the text with the mention of starting position and length,
using code line
With Selection.Characters(Start:=10, Length:=9).Font.colorindex = vbred
what I need to is to color the user-selected text, which is a variable.
Thanks in advance.