<div>
Adjusted points from 50 to 343
</div>


<div>
Please, does anyone have any ideas? &nbsp;Is it simply impossible? Or very difficult? &nbsp;
</div>


Please, does anyone have any ideas?  Is it simply impossible? Or very difficult?  

<div>
Thank you very very much... I'm just having a hard time believing it's that easy! &nbsp; I spent over 3 hours trying to work that out, and have now waited over 3 months for the answer! &nbsp;Thank-you very much!!
</div>


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!!

<div>
YIKES... &nbsp;I can't get that to work in a dialog box though. (It just works on the spreadsheet itself.) &nbsp;Is their any way to create an autofilter-like listbox in a form?
</div>


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?

<div>
<div class="content wysiwyg-content">
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. &nbsp;(I would like it to contain one of every different entry in the column, arranged alphabetically.) How do I do this? &nbsp;Is there a function I can use? Thank you. &nbsp;
</div>
</div>


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.  

Make an AutoFilter like listbox

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.