'=' Button

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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
Click to expand...

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
 
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
 
Back
Top