hi,
i have a table1 in Sheet("entry")
i want to filter table (field =3 and field =12) using textbox1 and textbox2
this filtered data want to show in listbox
thanx alot
hi,
i have a table1 in Sheet("entry")
i want to filter table (field =3 and field =12) using textbox1 and textbox2
this filtered data want to show in listbox
thanx alot
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Hi,
I would do this way:
1) load table into array
2) loop through array and if criteria from TextBox1 and TextBox2 are met - then load data to ListBox
Please upload sample file with your userform and some data in table1.
Or load entire table into ListBox and filter both columns in Listbox using RemoveItem.
Or use AdvancedFilter to create filtered list to load into ListBox.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi, kasan
here is sample workbook
and thanx for reply
Last edited by HaroonSid; 02-01-2017 at 09:22 AM.
Sample workbook
I dont know how many values you wish to add to the list box, I added 3 values. If you need more, then change ListBox column count (ColumnCount under Properties) and add values as I did it in the code.
Please Login or Register to view this content.
Thanx A lot dear kasan
its working perfectly
but if i want to add 33 column in list box
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks