The keyboard shortcut Ctrl+G brings up the Goto menu. From here, you could
type a cell address or range and then press enter to go there (just like the
name box). Also, it displays a list of any named ranges, which you can select
(using combination of Tab and Arrow keys.

So, while the Goto box is not *exactly* the name box, it appears to function
in the same way.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"danno-c" wrote:

Hello,

After a through review of help documentation I can not locate a keyboard
shortcut for moving the focus (cursor) to the "Name Box" portion of the
worksheet.
(Click link to see a screen shot of what I am referring to as the the "Name
Box")


BACKGROUND INFO:
Running MS Office Professional Edition 2003.

I am working with a process that requires me to quickly navigate to cels
within a very large worksheet and then perorm a series of actions, with the
cel contents, using a combination of keyboard shortcuts and macros.

To begin each series of actions I am currently typing the cel coordinates
(i.e. A567) and pressing enter to navigate to the target cel. After
completing the series of actions on the cel contents and before I can
navigate to the next cel, I must move from the keyboard to the mouse and
click on the "Name Box" to put focus there and then type my next coordinate
to initate the next series of actions.

I know this may sound trivial but this minor move from the keyboard to the
mouse is really slowing down what is otherwise a very efficient series of
keyboard short cuts and macros.

Does anyone know of a keyboard shortcut to place the cursor in the Name Box
area of the worksheet?

PS: I have been unable to get a macro to record a mouse click to put the
focus in the Name Box. If anyone knows how I can overcome this and thus
include the mouse click in a macro that would do just as well as a keyboard
shortcut.

Thank You
Dan