Make an AutoFilter like listbox

I would like to make a listbox based on a column of data in an Excel spreadsheet, just like the one generated when you turn the AutoFilter on.  (I would like it to contain one of every different entry in the column, arranged alphabetically.) How do I do this?  Is there a function I can use? Thank you.  
to_adamAsked:
Who is Participating?
 
riduceConnect With a Mentor Commented:
Range("D1:D15").Select
    Selection.Sort Key1:=Range("D1"), Order1:=xlAscending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
    Selection.AutoFilter
0
 
to_adamAuthor Commented:
Adjusted points from 50 to 343
0
 
to_adamAuthor Commented:
Please, does anyone have any ideas?  Is it simply impossible? Or very difficult?  
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
to_adamAuthor Commented:
Answer accepted
0
 
to_adamAuthor Commented:
Thank you very very much... I'm just having a hard time believing it's that easy!   I spent over 3 hours trying to work that out, and have now waited over 3 months for the answer!  Thank-you very much!!
0
 
to_adamAuthor Commented:
YIKES...  I can't get that to work in a dialog box though. (It just works on the spreadsheet itself.)  Is their any way to create an autofilter-like listbox in a form?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.