Alphabatizing Combo Boxes

[Guest]

I am wondering how I should go about alphabatizing the contents of a textbox.
As I remember sort is a property you can set to true in VB 6.0 but it is not
part of VBA.

Any help with this would be greatly appreciated,
Dave Marden

 

[Guest]

Actually I didn't mean textbox, I meant combo box, sorry 'bout the confusion.

Dave Marden

 

[Dave Peterson]

John Walkenbach has an example for populating a listbox with unique items. It
also includes a sort routine.

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

 

[Guest]

Thank You,
I greatly appreciate it.

Dave Marden