set dropdown list width in validation

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 ***

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" <[email protected]> wrote in message
news:[email protected]...
>
>
> 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 ***