Getting the user selected text in a text box shapes in xl sheet using vba

[Sanmrxl]

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.

 

[Legacy 456155]

The object model does not contain any property or method to fetch selected text. Not that I could find. You could use the clipboard to determine what is being selected and then InStr to determine the start arg. Though there may be multiple possibilities available in the entire text string. Show your method for coloring the selected text. After further consideration, maybe you could call a menucommand on the selected text. I'm betting that you can.