ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I expand the Name Box? (https://www.excelbanter.com/excel-discussion-misc-queries/34306-how-do-i-expand-name-box.html)

JohnnyQuick

How do I expand the Name Box?
 
When I name a range, it is posted to the Name Box (next to the formula bar).
However, the full name is not displayed due to the size of the name box.
Thanks.

Bob Phillips

See http://www.xldynamic.com/source/xld.Names.html#misc

--
HTH

Bob Phillips

"JohnnyQuick" wrote in message
...
When I name a range, it is posted to the Name Box (next to the formula

bar).
However, the full name is not displayed due to the size of the name box.
Thanks.




Chip Pearson

You can do this only through code. See
http://www.cpearson.com/excel/NameBox.htm for details.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"JohnnyQuick" wrote in
message
...
When I name a range, it is posted to the Name Box (next to the
formula bar).
However, the full name is not displayed due to the size of the
name box.
Thanks.




JohnnyQuick

Thanks Chip. I appreciate it!

"Chip Pearson" wrote:

You can do this only through code. See
http://www.cpearson.com/excel/NameBox.htm for details.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"JohnnyQuick" wrote in
message
...
When I name a range, it is posted to the Name Box (next to the
formula bar).
However, the full name is not displayed due to the size of the
name box.
Thanks.





JohnnyQuick

Thanks Bob. Both you and Chip gave me the solution.

"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.Names.html#misc

--
HTH

Bob Phillips

"JohnnyQuick" wrote in message
...
When I name a range, it is posted to the Name Box (next to the formula

bar).
However, the full name is not displayed due to the size of the name box.
Thanks.






All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com