How to filter listbox values based on a Textbox value

I sure hope the following piece of code is what you are looking for. Private Sub Textbox1_Change() Dim i As Long Dim arrList As Variant Me.ListBox1.Clear If TMP.Range(“A” & TMP.Rows.Count).End(xlUp).Row > 1 And Trim(Me.TextBox1.Value) <> vbNullString Then arrList = TMP.Range(“A1:A” & TMP.Range(“A” & TMP.Rows.Count).End(xlUp).Row).Value2 For i = LBound(arrList) To UBound(arrList) If InStr(1, arrList(i, 1), Trim(Me.TextBox1.Value), … Read more

ExtJs – Filter a grid with a search field in the column header

After quite much research through the sparse documentation, and thanks to great questions and answers in SO, I came up with a simple class, that adds this functionality and and allows for configurations. It looks like this: You add this field in your grid like this: Ext.define(‘Sandbox.view.OwnersGrid’, { extend: ‘Ext.grid.Panel’, requires: [‘Sandbox.view.SearchTrigger’], alias: ‘widget.ownersGrid’, store: … Read more

Powershell Get-ChildItem -Filter operates differently to Where clause with same value

The Filter of FileSystem provider rather uses CMD wildcards than PowerShell wildcards. CMD wildcards are funny and not intuitive in some edge cases, mostly historically. Here is an interesting explanation: https://devblogs.microsoft.com/oldnewthing/20071217-00/?p=24143 Another gotcha to be kept in mind: ls -Filter *.txt in fact gets files like *.txt* in PowerShell sense, i.e. files with extensions starting … Read more