Highlighted Text in Formula - Actions

[Nugget]

Hi all,
If I highlight a part of a formula and press F4 it will toggle through the absolute/relative references. OK, np.

Where can I pickup the highlighted region to do "other" things with it? For starters, highlight part of a formula press a shortcut key and have it add parenthesis around the highlighted text?


-- removed inline image ---


Regards,
Mon

 

[Peter_SSs]

One thing you can do is highlight part of a formula and press F9 to see the result of that part of the formula. Having done so ..
- press Esc to return the formula to how it was, or
- press Enter to permanently replace the highlighted part with the F9 result.

BTW, the link in your post does not work for me.

 

[Nugget]

Thank you, I am aware of this functionality. What I would like to do is add NEW abilities.
Sorry about the link, here is what I was trying to show.

=A1*B2+C1
=A1*B2+C1 ==> B2+C1 would be highlighted and after "new keystroke" would become
=A1*(B2+C1)

 

[Nugget]

Actually now that I think about it, what I need to know how to pick up what is highlighted. I was thinking something along the lines of

private:
   void textBox1_Enter(System::Object ^ sender,
      System::EventArgs ^ e) {
   if (!System::String::IsNullOrEmpty(textBox1->Text))
   {
      textBox1->SelectionStart = 0;
      textBox1->SelectionLength = textBox1->Text->Length;
   }
}

OR ACTUALLY!!! Just like the "Wrap

 around selected text" in this reply box!! I was just envisioning if I could pick up what was highlighted I could do whatever else I needed as well.