Name Box Width and Height
 

Hello,

I'm using Excel 10 SP3 on WIN XP Prof. 5.1 SP1

I know how to increase the width of the name box by using
Chip Pearson's "Increasing The Size Of The Name Box",
but I can't find a way to increase the hight.
Especially when I have to work with 50 names or more it would
help to find a name on the drop down.

A routine, which I can use in Excel's VBA environment would be great.
Thanks.

Regards
Werner

Name Box Width and Height
 

Have a look he
http://www.vbrad.com/article.aspx?id=23

RBS

"Werner Rohrmoser" wrote in message
ups.com...
Hello,

I'm using Excel 10 SP3 on WIN XP Prof. 5.1 SP1

I know how to increase the width of the name box by using
Chip Pearson's "Increasing The Size Of The Name Box",
but I can't find a way to increase the hight.
Especially when I have to work with 50 names or more it would
help to find a name on the drop down.

A routine, which I can use in Excel's VBA environment would be great.
Thanks.

Regards
Werner

Name Box Width and Height
 

Thanks a lot, I'm going to use the COM AddIn, which works fine.

Regards
Werner