Is there a keyboard shortcut that will allow me to place parentheses around a
highlighted formula (on the formula bar) with out typing '(' and ')' ?

hi
???????????????????
shift+9 and Shipt+0
???????????????????

-----Original Message-----
Is there a keyboard shortcut that will allow me to place
parentheses around a
highlighted formula (on the formula bar) with out
typing '(' and ')' ?
.

hi.
see this site for all known xl keyboards shortcuts. it's a
downloadable xl file.
I looked. none that i could find for what you want.
hope this helps you out.
FSt1
-----Original Message-----
Is there a keyboard shortcut that will allow me to place
parentheses around a
highlighted formula (on the formula bar) with out
typing '(' and ')' ?
.

Not that I know of -- you have to move the cursor and type them manually. And
you can't do it with a macro: you say you want to do this in the formula bar,
which means you are in Edit mode. Macros can't run in Edit mode.

On Tue, 1 Mar 2005 10:19:04 -0800, "jstewart46"
wrote:

Is there a keyboard shortcut that will allow me to place parentheses around a
highlighted formula (on the formula bar) with out typing '(' and ')' ?

jstewart46 wrote:
Is there a keyboard shortcut that will allow me to place parentheses around a
highlighted formula (on the formula bar) with out typing '(' and ')' ?

Control-X
(
Control-V
)

If you had a macro program or keyboard recorder, you could record this
sequence of keystrokes and assign it to a shortcut of your choice.

If you had a macro program or keyboard recorder, you could record this
sequence of keystrokes and assign it to a shortcut of your choice.

If he wants to operate on just the part of the formula that he has selected,
you can't record or run a macro to do it.

When you are editing in the formula bar, you can't turn on the macro recorder.
When you are editing in the formula bar, you can't run a macro, either.

If he always wanted to put parens around, say, the 5th through the 10th
characters, that could be automated with a macro. But he is out of luck if the
position and length is variable.

Myrna Larson wrote:
If you had a macro program or keyboard recorder, you could record this
sequence of keystrokes and assign it to a shortcut of your choice.


If he wants to operate on just the part of the formula that he has selected,
you can't record or run a macro to do it.

You can't record a run a VBA macro.

But there are plenty of other macro programs out there that will do the
trick, completely independently of what's happening in Excel.

When you are editing in the formula bar, you can't turn on the macro recorder.
When you are editing in the formula bar, you can't run a macro, either.

Third-party macro programs don't have this limitation.

Enlighten us. What programs are you talking about?

On Thu, 03 Mar 2005 12:10:46 -0500, Jonathan Rynd
wrote:

Myrna Larson wrote:
If you had a macro program or keyboard recorder, you could record this
sequence of keystrokes and assign it to a shortcut of your choice.


If he wants to operate on just the part of the formula that he has
selected,
you can't record or run a macro to do it.

You can't record a run a VBA macro.

But there are plenty of other macro programs out there that will do the
trick, completely independently of what's happening in Excel.

When you are editing in the formula bar, you can't turn on the macro
recorder.
When you are editing in the formula bar, you can't run a macro, either.

Third-party macro programs don't have this limitation.

Myrna Larson wrote:
Enlighten us. What programs are you talking about?

For instance...

Macro Magic -- www.iolo.com/mm
Macro Express -- www.macros.com
Macro Scheduler -- www.mjtnet.com

All of these can record and play back at any time.