Alphabatizing Combo Boxes
 

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

Alphabatizing Combo Boxes
 

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

Dave Marden

"Dave Marden" wrote:

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

Alphabatizing Combo Boxes
 

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

Dave Marden wrote:

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

Dave Marden

"Dave Marden" wrote:

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

--

Dave Peterson

Alphabatizing Combo Boxes
 

Thank You,
I greatly appreciate it.

Dave Marden