Q&D Sort Using Hidden List Box

VB has no built-in Sort function. Although lots of sort routines of varying complexity and performance are available, there’s a simple “cheat” that you might find useful. The standard VB ListBox control has a Sorted property. Anything you add to a list box will automatically be placed in its proper rank, if you set Sorted to True before running the program. (Sorted is read-only at run time.)

Then simply use the AddItem method to insert items, and the ListBox maintains them in sorted order. A couple things to watch out for: list boxes store everything as strings. Although you can use Evil Type Coercion (ETC) to load numbers into them, keep in mind that as strings, they’re sorted according to string rules. That means that 900 are perceived as greater than 1,000. This code uses random numbers and adds leading zeros to them as needed after ETCing them to strings. This code uses two CommandButtons, one ListBox, and one TextBox with its MultiLine property set to True. Click on Command1 to load up the ListBox, and click on Command2 to extract the data one element at a time and display it in Text1.

Don’t forget to set the ListBox’s Visible property to False for your real applications:

 Option ExplicitDim c As LongDim i As StringPrivate Sub Command1_Click()	List1.Clear	For c = 1 To 10		i = Int(Rnd * 10000)		While Len(i) < 4			i = "0" + i		Wend		List1.AddItem i	NextEnd SubPrivate Sub Command2_Click()	Text1 = ""	For c = 0 To List1.ListCount		Text1 = Text1 & List1.List(c) & vbCrLf	NextEnd Sub
Share the Post:
Share on facebook
Share on twitter
Share on linkedin


The Latest

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS

homes in the real estate industry

Exploring the Latest Tech Trends Impacting the Real Estate Industry

The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may