Macro to edit formula in cell
 

I have been reading questions/answers about the disappearance of the "=" sign
from the Excel 2000 formula bar, and different solutions for replicating its
functionality.

I have a user who used to select a cell with a number in it, click the "="
sign on the formula bar, which would insert an "=" sign in front of the
number, and place the insertion point at the end of the formula/string for
further appending to the edit. This is what she would like to continue doing.

I tried recording a macro that included these steps:
- Press F2 on the keyboard to enter Edit mode
- Enter an "=" sign from the keyboard
- Press the End key on the keyboard to place insertion point at the end

When I click "stop recording", since I'm in the middle of editing a formula,
the Stop Recording command does not work correctly. Does anyone have any
advice for creating a macro to accomplish this, without it getting all mucked
up by being in formula editing mode?

Thanks very much in advance,
Steve

Macro to edit formula in cell
 

I should add: the macro I'm trying to create needs to move the insertion
point to the start of the cell after entering Edit mode, so:

F2
Home
Equal sign
End

Just a clarification.... Thanks.

Steve

"Steve Vincent" wrote:

I have been reading questions/answers about the disappearance of the "=" sign
from the Excel 2000 formula bar, and different solutions for replicating its
functionality.

I have a user who used to select a cell with a number in it, click the "="
sign on the formula bar, which would insert an "=" sign in front of the
number, and place the insertion point at the end of the formula/string for
further appending to the edit. This is what she would like to continue doing.

I tried recording a macro that included these steps:
- Press F2 on the keyboard to enter Edit mode
- Enter an "=" sign from the keyboard
- Press the End key on the keyboard to place insertion point at the end

When I click "stop recording", since I'm in the middle of editing a formula,
the Stop Recording command does not work correctly. Does anyone have any
advice for creating a macro to accomplish this, without it getting all mucked
up by being in formula editing mode?

Thanks very much in advance,
Steve

Macro to edit formula in cell
 

Steve

Macros won't run or record while you are in Edit Mode.

Live with fact that Excel Developers did away with the feature.


Gord Dibben MS Excel MVP

On Tue, 8 Jan 2008 15:30:01 -0800, Steve Vincent
wrote:

I should add: the macro I'm trying to create needs to move the insertion
point to the start of the cell after entering Edit mode, so:

F2
Home
Equal sign
End

Just a clarification.... Thanks.

Steve

"Steve Vincent" wrote:

I have been reading questions/answers about the disappearance of the "=" sign
from the Excel 2000 formula bar, and different solutions for replicating its
functionality.

I have a user who used to select a cell with a number in it, click the "="
sign on the formula bar, which would insert an "=" sign in front of the
number, and place the insertion point at the end of the formula/string for
further appending to the edit. This is what she would like to continue doing.

I tried recording a macro that included these steps:
- Press F2 on the keyboard to enter Edit mode
- Enter an "=" sign from the keyboard
- Press the End key on the keyboard to place insertion point at the end

When I click "stop recording", since I'm in the middle of editing a formula,
the Stop Recording command does not work correctly. Does anyone have any
advice for creating a macro to accomplish this, without it getting all mucked
up by being in formula editing mode?

Thanks very much in advance,
Steve

Macro to edit formula in cell
 

Thanks for the last nail in the coffin, Gord. I guess I'll give in!

Thanks,
Steve



"Gord Dibben" wrote:

Steve

Macros won't run or record while you are in Edit Mode.

Live with fact that Excel Developers did away with the feature.


Gord Dibben MS Excel MVP

On Tue, 8 Jan 2008 15:30:01 -0800, Steve Vincent
wrote:

I should add: the macro I'm trying to create needs to move the insertion
point to the start of the cell after entering Edit mode, so:

F2
Home
Equal sign
End

Just a clarification.... Thanks.

Steve

"Steve Vincent" wrote:

I have been reading questions/answers about the disappearance of the "=" sign
from the Excel 2000 formula bar, and different solutions for replicating its
functionality.

I have a user who used to select a cell with a number in it, click the "="
sign on the formula bar, which would insert an "=" sign in front of the
number, and place the insertion point at the end of the formula/string for
further appending to the edit. This is what she would like to continue doing.

I tried recording a macro that included these steps:
- Press F2 on the keyboard to enter Edit mode
- Enter an "=" sign from the keyboard
- Press the End key on the keyboard to place insertion point at the end

When I click "stop recording", since I'm in the middle of editing a formula,
the Stop Recording command does not work correctly. Does anyone have any
advice for creating a macro to accomplish this, without it getting all mucked
up by being in formula editing mode?

Thanks very much in advance,
Steve