Drop Down List:using a filter

**clarabelle** · 06-21-2007, 05:31 AM

Good Morning All,

Is it possible to have a drop down list, i.e. locations, in a worksheet which the user can select without using a filter?

Cheers

Claire

**starguy** · 06-21-2007, 05:36 AM

Originally Posted by clarabelle

Good Morning All,

Is it possible to have a drop down list, i.e. locations, in a worksheet which the user can select without using a filter?

Cheers

Claire

Hi

See the link below

http://www.contextures.com/xlDataVal01.html