Excel Name Box

[bass1166]

Excel 2003: I would like to resize the Name Box so that I can see the entire Name I have assigned. Can this be done easily?

 

[Keebellah]

Hi, welcome to the forum, as far as I know you'll have to contact Bill Gates
Works as desgined

 

[WendyM]

You can't widen the name box itself in 2003 (though you can in later versions), but you can use VBA to widen the name dropdown, if that's useful.

http://www.cpearson.com/excel/NameBox.aspx

 

[bass1166]

Wendy, I tried the VBA from Hans. It worked great. Thanks everyone. (a VBA novice).

Do you happen to have a suggestion for pausing a macro for user input, then continuing with operation?

 

[WendyM]

Do you happen to have a suggestion for pausing a macro for user input, then continuing with operation?

There are different ways to do this depending on what you want the user input to be, but it's probably better to start a new thread with this question since it's not related to widening the name box. That will give more people an opportunity to look at it and help.