If you use a combobox from the control toolbox you can do that, not if you
use validation

--
Regards,

Peo Sjoblom


"Mick Elliott" wrote in message
...
how do I widen a drop down box in a worksheet so that I can read the
contents, without widening the column
--
Mick