Data validation doesn't allow this. If you want this kind
of function, then you will need to use a combo-box. A
macro won't help in this situation.

-----Original Message-----
i have a list of fund names say 1000.
i use data validation and want to select a particular
fund name like a
combo box does.
but i dont want to scroll down all the way to see fund
say for ex. T
but as i type type T i shud go to all the funds named
with T . this is
like making it recognise the 1 st alphabet of the fund .

can i do this or do i have to write a macro ?
can anyone plsssssss help.
can u mail me the answer at
thanks a lot !!!!!!!!
sam.
.