MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by KRIS on August 17, 2001 11:08 AM

Is there a way I create a shortcut key for a common phrase that I use(example - 7a to 7p) instead of typing 7a to 7p every time is there a way where I could just type/holddown "Ctrl z" ?

Please help

Posted by neo on August 17, 2001 11:48 AM


goto View -> Toolbars -> Visual basic and select the blue dot. in the box that pops up put a 'z' in the shortcut key place and select OK. when a tiny box pops up with a blue square in it, goto a cell and type '7a to 7p'. almost there... press the blue square, then on the VB toolbar press the play button (blue triangle on its side) then select edit. in the new window that pops up, you'll see a large white portion that has your macro's code in there. there should be a line that starts with 'range("??").select. delete this line. in fact, leave only the lines that say :

Sub Macro1()
ActiveCell.FormulaR1C1 = "7a to 7p"

End Sub


close all of that out and go back to your sheet. now choose a cell and press Cont + z

it work?


Posted by Ian on August 18, 2001 3:42 AM

It will but I don't like the advise you've given!!

The example given will take away the Ctrl + z Undo function (very unwise if like me you need to undo a LOT)
I'd suggest you put a capital Z in the box mentioned then to the left of that will change to Ctrl+Shift+Z this is the new short cut
or use another letter :)
if you put the letter in caps you can see if it is used already by wether it changes to c+s

Any help