John Walkenbach shows how to get a list of unique values from a range to
populate a listbox.

Maybe you could change his code:

http://j-walk.com/ss/excel/tips/tip47.htm

(I didn't look at the attachment.)

"kaon <" wrote:

Hi all,

Is there any quick ways that I can obtain all available options of each
fields? (as shown in the attachment)

If not, any idea. I just came up using CountA() to get each distinct
options.

Attachment filename: autofilter.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=644783
---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson