Goto / Name Box

[Ron Wood]

Hi Group,

How do I increase the width of the aforementioned? or is it even possible?

Some of my range names are quite long and the current width makes it
difficult to figure out which are which, for example:

PHOTOGRAPHIC - Courses
PHOTOGRAPHIC - Libraries
PHOTOGRAPHIC - Fulfillment

etc, all show as PHOTOGRA...

TIA, Ron

--
Regards, Ron

=================================
www.MinsterEbooks.co.uk the ebook site
with a difference. Samples - "Try Before
You Buy", Some ebooks in hardcopy
are avauilable on ebay ID: ronwood50.
================================

 

[Gord Dibben]

I have not heard of a way to increase the Go To dialog window.

But hang in, someone may have written some code to do so similar to Robert
Gelb's namebox resizer found at.

http://www.vbrad.com/pf.asp?p=Source/src_excel_namebox.htm


Gord Dibben MS Excel MVP

 

[Ron Wood]

Hi Group,

How do I increase the width of the aforementioned? or is it even possible?

Some of my range names are quite long and the current width makes it
difficult to figure out which are which, for example:

PHOTOGRAPHIC - Courses
PHOTOGRAPHIC - Libraries
PHOTOGRAPHIC - Fulfillment

etc, all show as PHOTOGRA...

TIA, Ron

[/QUOTE]

I have not heard of a way to increase the Go To dialog window.

But hang in, someone may have written some code to do so similar to Robert
Gelb's namebox resizer found at.

http://www.vbrad.com/pf.asp?p=Source/src_excel_namebox.htm


Gord Dibben MS Excel MVP

Thanks Gordo it looks as if that will do the job, will try it later.

Ron

 

[Gord Dibben]

Good luck.

Gord

Thanks Gordo it looks as if that will do the job, will try it later.

Ron

 

[Ron Wood]

Good luck.

Gord

Works a treat, thanks Gord.

 

[Gord Dibben]

Good to hear.

Thanks for the feedback and to Robert Gelb for the code.


Gord