Скачать
Dynamic Filter in MS Excel 2013 - Filter As You Type (With VBA)
Автор: Excel Dose
Загружено: 2020-04-03
Просмотров: 8835
Описание:
In this video you will learn how to create Dynamic Filter (Searchable filter) in Excel 2013
VBA Code:
Private Sub TextBox1_Change()
Application.ScreenUpdating = False
ActiveSheet.ListObjects("Data").Range.AutoFilter Field:=2, Criteria1:="*" & [C1] & "*", Operator:=xlFilterValues
Application.ScreenUpdating = True
End Sub
***************************
Subscribe: https://www.youtube.com/c/exceldose?s...
Follow us on Facebook: / exceldose
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
![Real-Time Data Search Box in Excel with FILTER function [Part 1]](https://image.4k-video.ru/id-video/gHXalY5rngI)
