View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default 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