"jinvictor" wrote:
a1 is droplist which contain information,(china,australia.....)
i want to do is:
every time i choose china in a1, there will be a pre set line insert in
a2,(that line got all the functions i pre setup), but when i chose other
countries in a1, nothing change.

Perhaps in A2, something like:
=IF(A1<"china","",<your function)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---