'=' Button

[Bob]

Excel 2003 makes available a custom toolbar button for the equals sign.
When you click the equals sign an equals sign is placed in the active
cell and the insertion sign (the lower dash) is located right after the
= in the same active cell. I like using this to build formulas and
combine it with some of the other buttons such as +,-,/, and *.

Is there a way to create a macro that does this same thing? I would
like to create some for other keyboard entries. I haven't been able to
find a way to insert a character and keep the cell active as done with
the equals sign button.

Thanks

 

[Beege]

Excel 2003 makes available a custom toolbar button for the equals sign.
When you click the equals sign an equals sign is placed in the active
cell and the insertion sign (the lower dash) is located right after the
= in the same active cell. I like using this to build formulas and
combine it with some of the other buttons such as +,-,/, and *.

Is there a way to create a macro that does this same thing? I would
like to create some for other keyboard entries. I haven't been able to
find a way to insert a character and keep the cell active as done with
the equals sign button.

Thanks

Bob,

Have you tried using the F2 key when in a cell? A macro will still need a
key pressed, and F2 is already there...

Beege

 

[Gord Dibben]

Macros will not run while you are in edit mode so I would say it can't be done.

You can create a macro to enter the character in the cell, but not keep the cell
active for further editing.


Gord Dibben MS Excel MVP