Click here to Skip to main content
15,885,910 members

Comments by johnywhy (Top 3 by date)

johnywhy 21-Sep-21 13:19pm View    
i'm unclear that these are the same technique. One seems to use Windows Script Host (wshom.ocx), the other seems to use Microsoft Scripting Runtime (scrrun.dll).
johnywhy 21-Sep-21 13:18pm View    
Deleted
i'm unclear that these are the same technique. One seems to use Windows Script Host (wshom.ocx), the other seems to use Microsoft Scripting Runtime (scrrun.dll).
johnywhy 14-Dec-16 11:15am View    
False. You can place a textbox just above the listbox, allowing user to type a filter-string into the textbox. Eg:

Whi

Then, your VBA code would filter the contents of the listbox to items that begin with whatever filter-string the user typed. I've done this, and it can be very fast.