Macro to edit formula in cell

[Steve Vincent]

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

 

[Steve Vincent]

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

 

[Gord Dibben]

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

 

[Steve Vincent]

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

Thanks,
Steve