Hi experts,

I have a minor problem....

In column D i have a data validation list in each cell.
Until now, I had only 100 lines in my application. The size of the
application was about 300kb

Because i do not know how many lines the user will put in, i have made all
cells ranging from D4:D65000 with datavalidation.

Now my application is about 1.700kb
Is there a way to only have a data validation (dropdownlist) in column D when
the user puts something in column B on the same line ?

How would i program that in VBA ?

Thanks,
Pierre

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200601/1