| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Alphabatizing Combo Boxes
Thank You,
I greatly appreciate it. Dave Marden |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
| Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
| Questions on combo boxes and list boxes. | New Users to Excel | |||
| List boxes/combo boxes | Excel Programming | |||
| Combo Boxes | Excel Programming | |||
![Dave Marden[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
