Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data-Validation-List-Width of list must be colomn width, is this possible
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data-Validation-List-Width of list must be colomn width, is this
See Colo's Excel Junk Room for some code to do this. See also my post from
earlier today (03-05-07) trying to implememt a slightly modified version of that code - having an intermittant problem with it. "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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data-Validation-List-Width of list must be colomn width, is this possible | Excel Worksheet Functions | |||
HOW DO YOU SET THE DEFAULT FIXED COLOMN WIDTH ON THE EXCEL IMPORT | Excel Discussion (Misc queries) | |||
Drop down list box width - data validation | Excel Discussion (Misc queries) | |||
set dropdown list width in validation | Excel Programming | |||
How do I change the width of the data validation list box? | Excel Discussion (Misc queries) |