Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to edit formula | Excel Discussion (Misc queries) | |||
Edit macro to match entire cell contents | Excel Discussion (Misc queries) | |||
How can I edit cell contents with a macro in Excel? | Excel Discussion (Misc queries) | |||
How can I edit cell contents with a macro in Excel? | Excel Discussion (Misc queries) | |||
How do I edit a formula as part of a macro? | Excel Discussion (Misc queries) |