Hi X Taol,
Visit Debra Dalgleish's Contextures site and lookat:
http://www.contextures.com/xlDataVal08.html#Wider
and
http://www.contextures.com/xlDataVal08.html#Larger
---
Regards,
Norman
"x taol" wrote in message
...
i want to adjust the width of dropdown box in case long strings in
validation list using macro.
i want to adjust to width of letter with maximum length of lists.
*** Sent via Developersdex http://www.developersdex.com ***