S
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
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