With either a list or combo box the approach is the same. These properties
will be useful to read about in Help:
..MatchEntry
..MatchRequired & .Style (Combo only)
..ListFillRange
..LinkedCell

NickHK

wrote in message
oups.com...
i found my prob i have used a dropdown list so i am using a combo box
and not a list box. since i am using a dropdown list and the list is
being populated by another column of data in the same sheet.so i will
have to stick to that. now tel me how i can handle that.
either i should be able to populate my data column in the list box
(which incidentally i dont know how to :-)) and then use ur idea.
or find a solution with the use of a combo box