View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Vincent Steve Vincent is offline
external usenet poster
 
Posts: 32
Default 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