Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2006

Tip: Looking for answers? Try searching our database.

'=' Button

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob@1800-mail.com - 19 Jun 2006 14:27 GMT
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 - 19 Jun 2006 14:42 GMT
> 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
[quoted text clipped - 8 lines]
>
> 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 - 19 Jun 2006 15:41 GMT
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

>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
[quoted text clipped - 8 lines]
>
>Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.