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
|