Expanding the 'Refers To' Box in the Define Name Dialog Box

B

Bichon Bert

I'm trying to get my head around Excel Programing using VBA. I'm
reading various books, some of which provide examples on CD.
On the subject of named formulas, when I look in the examples using the
define name dialog box, the actual formula completely fills the 'Refers
to' box.

Is there a way of expanding this box so I can see the contents in
total.

The same thing happens in the Data Validation dialog box when I select
List, I cant view the complete entry in the source box.

It's probably something very elementary and your help would be
gratefully received.

Thanks
 
D

Dave Peterson

I don't know of a way to expand those dialogs, but for the Insert|name dialog,
you could use a different tool:

Get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

The dialog is resizable so you can see more of the formula.

(Or you could just select the formula/list from any dialog and copy it. Paste
into notepad to see the whole thing.)
 
Top