There's a sample file here that does this with programming:
http://www.contextures.com/excelfiles.html
Under Data Validation, look for 'DV0012 - Update Validation List'
> Hi All,
>
[quoted text clipped - 5 lines]
>
> Mosaddeq Aziz

Signature
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
Mosaddeq Aziz - 14 Jun 2007 12:44 GMT
Description looks exactly what i wanted. Thanks Debra for the link.
Mosaddeq Aziz
>There's a sample file here that does this with programming:
>
[quoted text clipped - 11 lines]
>>
>> Mosaddeq Aziz