Width of Active Cell Name drop down combo list

[John Google]

Is there any way to make the width of the drop down combo box wider in
Excel XP.

The one I'm referring to is the one in the top left (to the left of
the formula bar) which shows the active cell name.

I tend to use long names for my named ranges so, when I click the drop
down arrow, it only shows the first part of the name. Ideally, I would
like it twice as wide.

John.

 

[Rick Rothstein \(MVP - VB\)]

It doesn't look like you can change its size; however, you can get a longer
field to work with by clicking Insert/Name/Define on Excel's menu bar.

Rick

 

[Rick Rothstein \(MVP - VB\)]

If you think this "solution" will work for you, you can save yourself one
menu item click and a little searching for the Name item by adding a button
to the toolbar giving you direct access to Name sub-menu. Right click the
toolbar and select Customize from the popup menu that appears; select the
Commands tab; click on Built-in Menus in the Categories list box; then
select Name from the Commands list box; drag that entry onto one of your
toolbars and drop it there; close the dialog box. You can now click the Name
button and immediately select Define from its drop-down menu.

Rick

 

[Gord Dibben]

John

Some options to explore ..

1. Try Chip's:
http://www.cpearson.com/excel/NameBox.htm

2. From a Tom Ogilvy posting:

Robert Gelb wrote a program that allows you to resize
the namebox itself.

http://www.vbrad.com/pf.asp?p=Source/src_excel_namebox.htm
(Two versions--one for xl97 and one for xl2k and above.)

3. From a JKP posting:

If you use defined names a lot, consider downloading the Name manager (by
Jan Karel Pieterse, Charles Williams & Matthew Henson) from:

www.bmsltd.co.uk/mvp


Gord Dibben MS Excel MVP

 

[Rick Rothstein \(MVP - VB\)]

Some options to explore ..

1. Try Chip's:
http://www.cpearson.com/excel/NameBox.htm

Looks like the link has changed to this...

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

Rick

 

[John Google]

John

Some options to explore ..

1. Try Chip's:
http://www.cpearson.com/excel/NameBox.htm

Thanks Gord!

After reading your post I tried option 1 which took me three minutes
to create a macro in my personal wb. It works a treat.

Brilliant advice.

John.

 

[Gord Dibben]

Thanks Rick

Going to the URL I posted one does get a "click here" link.

I'll try to remember to update.

Don't get much call for that particular page.


Gord