Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Shortcut into Name box
Hi there. Using E02 on XP. I'm using the Name box (above
A1) and wonder if there isn't a keystroke to 'jump' into it quickly? Thanks in advance for any help! |
#2
|
|||
|
|||
Depends on what you use it for. If you quickly want to jump to a named
range, you can also use F5. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Bonnie" wrote in message ... Hi there. Using E02 on XP. I'm using the Name box (above A1) and wonder if there isn't a keystroke to 'jump' into it quickly? Thanks in advance for any help! |
#3
|
|||
|
|||
I use the following macro assigned to Ctrl+Shift+N.
Public Declare Function SetFocus Lib "user32" (ByVal hwnd As Long) As Long Public Declare Function FindWindow Lib "user32" Alias "FindWindowA" _ (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Public Declare Function FindWindowEx Lib "user32" Alias "FindWindowExA" _ (ByVal hWnd1 As Long, ByVal hWnd2 As Long, _ ByVal lpsz1 As String, ByVal lpsz2 As String) As Long Sub SetFocusNameBox() Dim Res As Long Res = SetFocus( _ FindWindowEx( _ FindWindowEx( _ FindWindow("XLMAIN", Application.Caption) _ , 0, "EXCEL;", vbNullString) _ , 0, "combobox", vbNullString)) End Sub "Bonnie" wrote in message ... Hi there. Using E02 on XP. I'm using the Name box (above A1) and wonder if there isn't a keystroke to 'jump' into it quickly? Thanks in advance for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut menu does not have hyperlink on it | Excel Discussion (Misc queries) | |||
Shortcut key to move to beginning of a worksheet | Excel Discussion (Misc queries) | |||
Macro Shortcut Keys | Excel Discussion (Misc queries) | |||
How to make [toggling] shortcut keys to superscript and subscript, respectively? | Excel Discussion (Misc queries) | |||
Is there a keyboard shortcut for centering data in Excel? | Excel Discussion (Misc queries) |