View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Data-Validation-List-Width of list must be colomn width, is this

There is no provision for it. Debra Dalgleish has a page that shows a method
to use code to manage a Combobox from the control toolbox toolbar to simulate
the data validation dropdown. You can control the width of the dropdown list
in that control

I don't have the exact URL of that page, But it is in the Data validation
section of here site:

Debra Dalgleish
http://www.contextures.com/tiptech.html

Datavalidation - top
http://www.contextures.com/xlDataVal01.html

--
Regards,
Tom Ogilvy

"Luc" wrote:

Hello,



Is there a way that when you click in the cell, and when the list shows,
that you can make the width of the unfolded list wider than the column ?



The properties of all the cells in the column are 'wrapped' so the entire
text is visible.

But the text in the list is than the width of the column, so not
everything is visible in the list (after you make the selection in the list,
the text in the cell is wrapped).



Thanxxx,





Luc



--------------------------------------------------------------------------------

Mijn Postvak In wordt beschermd door SPAMfighter
344 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!