Move Cursor to Name Box

[damaniam1604]

First off, I believe there is a previously answered post but I can't find it for the life of me.

I am looking assign a short cut to a macro that places the cursor in the Name Box so I can enter the desired value. I don't want to use the dialogue box that appears when you press F3. I would like for the reference to be the selection of the current workbook. Thanks in advance.

 

[Michael M]

Here 'tis

http://www.cpearson.com/excel/NameBoxShortcut.htm

 

[damaniam1604]

Michael,

Could you give me some insight on how to place this code into my persona workbook. I inserted a new module and pasted it there, but it didn't work. Is there a specific reference I need to enable?

Thanks!

 

[Michael M]

It works fine for me.
Did you assign the shortcut key....Chip suggested CTRL + SHIFT+ N
Keep in mind, the name box WILL NOT be highlighted....after you press the shortcut key/s type a cell reference, it will appear in the name box.....there is no flashing cursor or oher ID to suggest the namebox is active !

 

[damaniam1604]

I opened a new workbook and closed all other projects. It worked. Thanks for your help.