+ Reply to Thread
Results 1 to 1 of 1

Filter as you type works slow

  1. #1
    Registered User
    Join Date
    01-29-2014
    Location
    ahmedabad
    MS-Off Ver
    Excel 2007
    Posts
    59

    Filter as you type works slow

    Hi, I have a file with about 4000 rows (and keeps on increasing) and I am using textbox to filter the data but seems like it is a bit slow, especially with common alphabets like a or e. Also I have a clear button to clear the filters and it takes quite a few seconds to complete. Is there any way I can speed up the filter process? I have attached the demo file here. Also, just to mention, I would really prefer filter along with typing as compared to writing the word and then using search button.

    Also, This file would be used on old dual core desktops so although it may not seem too slow for recent computers, it gets quite a bit affected on older computers.

    Appreciate all the help I can get... Thanx a lott....
    Attached Files Attached Files
    Last edited by taralmehta15; 01-09-2019 at 12:10 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro works but its Slow
    By nn90 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-13-2014, 01:30 PM
  2. Data Validation on SelectionChange - Works but slow!
    By JFangExcel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-08-2014, 12:12 PM
  3. Expand rows macro works, but is slow. Is there another solution?
    By markppp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 12:23 PM
  4. After printing ,the macro works very slow
    By yoav_b in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-05-2007, 04:31 AM
  5. Excel Works very slow in one section.
    By vikas.bhandari in forum Excel General
    Replies: 7
    Last Post: 02-09-2007, 08:20 AM
  6. [SOLVED] Code works but is slow except when....
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2006, 04:35 AM
  7. Code works, but is slow
    By EMoe in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-25-2005, 05:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1