Ok, no problem. I'll try (Should work in 2000):

1.Go to Sheet2 and select this area A1:A4
2.From the menu, choose Insert-Name-Define...
3.Type the desired name e.g. MyArea

(Note while giving a name: Can not start with digit and can not conflict
with cell addresses. No symbols, spaces. e.g. ILLEGAL names A1, %ABC, 1ACB,
abc def)

4.Click OK
5.Select the sheet and cell where you wish to have the list.

6.Data-Validation..."Allow"-field: list
7."Source"-field: type the range name you gave earlier or while cursor
blinking press F3 to choose name
8. OK

Hope this helps

Mr Mika :)

"DCG-jaeson" wrote in message
...
Hi Miss Mika,

I am just a little bit slow in picking up some ideas, please detailed
your suggestion, i dont know how to NAME a Source Range. and also when
i am in Source Field the "F3" won't do anything. By the way, my excel
is only 2000.

Please help me. Huhu! Thank you!
~jaeson