Re: Macro to edit formula in cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Thanks,
Steve



"Gord Dibben" wrote:

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

On Tue, 8 Jan 2008 15:30:01 -0800, Steve Vincent
<SteveVincent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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

"Steve Vincent" wrote:

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


.

Relevant Pages

  • Re: Macro to edit formula in cell
    ... Macros won't run or record while you are in Edit Mode. ... Live with fact that Excel Developers did away with the feature. ... I tried recording a macro that included these steps: ... When I click "stop recording", since I'm in the middle of editing a formula, ...
    (microsoft.public.excel.misc)
  • Excel 2007 macro problem in editing a cell
    ... I need to edit these to contain an email address of info@ the original URL, ... When I replicate the manual steps that work by using the macro recorder with ... the cell I used for recording, e.g. info@xxxxxxxxxxxxx, and it is formatted ... why the recording fails to give the same results as the manual steps. ...
    (microsoft.public.excel.programming)
  • Re: Excel 2007 macro problem in editing a cell
    ... Then run this macro on the column. ... Dim Cell As Range ... I need to edit these to contain an email address of info@ the original URL, ... why the recording fails to give the same results as the manual steps. ...
    (microsoft.public.excel.programming)
  • Re: Newbie needs assistance with VBA code
    ... I did as suggested and recorded the macro ... clicked on row 2 and clicked on edit, ... clicked on the active exceptions worksheet to activate and deleted the now ... Stop recording. ...
    (microsoft.public.excel.programming)
  • Re: Invoke Edit Mode
    ... I thought I would start recording a macro, hit F2 to enter edit mode, then stop recording to see what the VBA code was, but you cannot stop recording a macro while in edit mode. ...
    (microsoft.public.excel.programming)