Results 1 to 5 of 5

Thread: Keyboard Shortcut for Name Box
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2013
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Keyboard Shortcut for Name Box

    Hi,

    I would like to have a keyboard shortcut which moves the cursor into the Name Box to:
    - enter a new name or address for selected range,
    - copy the address/name of selected range.
    Just like when you use mouse to reach the Name Box, it sets the focus and selects its content.

    I'm trying to use Chip Pearson's macro: Defined Name Box Shortcut.

    Using this code I do can move cursor into the Name Box (I can type a name or a address) but when focus is set into the Name Box the content of the Name Box has disappeared.

    Is it possible to keep and select automatically Name Box content using Chip Pearson's solution?

    I'm using Excel 2010 32bit, Windows 7 SP1 64bit.

  2. #2
    Board Regular
    Join Date
    Dec 2009
    Posts
    900
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Keyboard Shortcut for Name Box

    Welcome to the forum have you tried this:

    Select your range of data then use Ctrl + Shift + F3 which will name the selected range with suggestions for you.

  3. #3
    New Member
    Join Date
    Aug 2013
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Keyboard Shortcut for Name Box

    Quote Originally Posted by healey21 View Post
    Welcome to the forum have you tried this:

    Select your range of data then use Ctrl + Shift + F3 which will name the selected range with suggestions for you.
    Hello. Thanks but Ctrl + Shift + F3 opens a new window Create Names from Selection and I can do it easily with Chip Pearson's macro, it's not a problem. The problem is to copy the text visible in Name Box using only keyboard.

  4. #4
    New Member
    Join Date
    Jan 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Keyboard Shortcut for Name Box

    alt f3

  5. #5
    New Member
    Join Date
    Dec 2018
    Location
    Kerala, India
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Keyboard Shortcut for Name Box

    ALT + F3 is the shortcut to Excel Name Box
    CTRL + F3 for Name Manager
    CTRL + SHIFT + F3 for Creating Names from Selection
    F3 for Paste names dialog Box

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •