Hi,

I've a cell with data validation. Only values 'x' and 'y' can be input. The
cell (column) has small width. When I enter the cell an arrow becomes visible
on the right side. Clicking the arrow gives a combobox with selectable
values. The width of the combobox is default the cell with plus the width of
the arrow.

Now in my case the width of the combobox is very large in comparison with
the default. And it looks very bad with 'x'and 'y'. How can I deminish that
width?

Thanks for help

Henk

We do not seem to have any control over the drop down's width.

--
Jim
"hstijnen" wrote in message
...
| Hi,
|
| I've a cell with data validation. Only values 'x' and 'y' can be input.
The
| cell (column) has small width. When I enter the cell an arrow becomes
visible
| on the right side. Clicking the arrow gives a combobox with selectable
| values. The width of the combobox is default the cell with plus the width
of
| the arrow.
|
| Now in my case the width of the combobox is very large in comparison with
| the default. And it looks very bad with 'x'and 'y'. How can I deminish
that
| width?
|
| Thanks for help
|
| Henk