Filter while typing in a cell
Would that be possible to dynamically filter rows based on a value that I type in a cell? Suppose I have a column-range with data A10:A1000 and I filter that range on criteria I am typing in A1 cell.
I want the filter to react dynamically, in a run time, as I am typing, not after I hit [Enter]. I found a solution for that with a text box. http://www.vbforums.com/showthread.php?647621-Excel-filtering-while-typing
However, preferably, I would like to do typing in a cell not in some text box. Is it possible?
I ended up using the solution based on pivot tables. It filters hundreds of items on the file, narrowing results after typing each letter. What is more, it allows to select multiple items.
I put the item list to page filter of the pivot table. You can hide the entire rows below the page filter for aesthetics so it does not even look like a pivot table, but just a cell for type/drop-down selection of the value.
- Private Sub for hiding worksheets based on cell value "View" / "Hidden"
- EDI translator to excel
- How to get the path of current worksheet in VBA?
- vba + copy sheet from one wb to another wb
- Word VBA macro with multiple find/replace options for single-word selection only works if the selection contains the first F/R option
- Sum values based on three criteria and transpose result from tabular to visual layout
- VBA Code Save in Local and Upload to Sharepoint
- Difference in regular expressions in Find_and_Replace and RegExp
- VBA CountIf() loop / Countifs() loop
- Copy cell values to another worksheet based on cell value
- M Code(Power Query) to Remove Empty columns that runs fast
- How can I send Excel range including header, in table, and email to list?
- Dropdown Lists Emptying When Filling Data in Worksheet
- How to get an item value from JsonObject
- excel vba projects not closing
- How do you copy and paste entire row of source sheet to destination when a date appears in specific column?
- How to border cells based on where the user click?
- Difference between running a userform in Visual Basic Editor (F5) and opening it with Show?
- VBA delete row working in one for loop but not another
- How to get HEX color value from cell color?
- Remove columns if the number of rows is less than a certain number using vba Excel
- VBA Security : my vbe password is well-set, but still can be hacked by a simple code
- Adjust vertical scrollbar range in Excel userform listbox
- Delete user ribbon from file
- Excel Hide/Show all tabs on Ribbon except custom tab
- Partial value font color in red using vba
- How do I conditionally append a row of Excel data from one sheet to another?
- Efficient formula or code to determine number of errors in range VBA
- Insert a Cover Page using vba
- Delete VBA module