9/8/2023 0 Comments Excel Vba Userform ExamplesFortunately by using arrays filtering and updating became incredibly fast. Surprisingly it worked pretty well until ~1.000 items, but it did not on 3.000+ items… After every key press it took ~1-2 secs to update the list boxes (search term length not limited and there were very long product names). Pretty straightforward right? It is, though to be honest I made a big mistake in the first version, during the filtering I looped through the background table and added the items one by one to the list boxes if the item matched with search term. filtering the base list as the users type the search term and continuously update the list boxes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |