Upgrade to xl2003 and use Data|Filter.

Else you'll have to provide your own symbols and your own code to sort.

"Erik K via OfficeKB.com" wrote:

How can I add a drop down menu into a cell with options of ascending and
descending?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200512/1

--

Dave Peterson