Move Cursor to Name Box

damaniam1604

New Member
Joined
Sep 12, 2018
Messages
20
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.
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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!
 
Upvote 0
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 !
 
Last edited:
Upvote 0

Forum statistics

Threads
1,212,927
Messages
6,110,697
Members
448,293
Latest member
jin kazuya

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top