Formula bar right click menu

[izakl]

Hi,

I would like to select text (a keyword) from a string in a cell and add the selected text to a range. I've added a command to the cell menu which displays the current selection in a MsgBox (for now..), but once some text in an active cell is selected (double click and select), a different right click menu appears which doesn't list my custom command.


How does one add a command to the cell menu (right click menu) which appears when the cursor is active in the formula bar?

Thanks.

[Winon]

Goeie more izakl,

Welcome to the Forum.

I do not have Excel versions other than 2007, but I don't think it is possible to add a command to the cell menu (right click menu) which appears when the cursor is active in the formula bar.

[izakl]

Thank you Winston

Thanks for your quick response.

That would be a pity... I'll check in later and see if someone posted a solution.

[izakl]

Sorry, I see it is Winon! My apologies