How to read table in an array and populate a listbox with the array

**waimea** · 03-01-2019, 03:15 AM

I have a multicolumn listbox named listbox1 and I want to populate the listbox with an array to speed up things.

My table is called Table1, my array is called TheArray and my textbox that I want to search the array with is named textbox1.

If possible, I would like to count the number of items when I am searching and remove blank entries below search results in the listbox.

Please Login or Register  to view this content.

This code doesn't work but it's what I have right now.

I want to:

1. Read multi-column table into an array
2. Populate a listbox with the array
3. Search the array

**rorya** · 03-01-2019, 04:26 AM

Your code already does 1 and 2. To iterate the array, you need to refer to both dimensions of it, not just one, just as if you were reading cells.

**waimea** · 03-01-2019, 04:40 AM

Thank you for your reply! I googled and came up with:

Please Login or Register  to view this content.

How can I search the array with a textbox? Should I redim TheArray ?

**rorya** · 03-01-2019, 07:40 AM

What do you want to do with the result(s)? Which column(s) do you need to search?

**waimea** · 03-01-2019, 07:42 AM

Hi rorya,

thank you for your reply!

I want to show the results in a listbox so when I type "S" in the textbox I get all items starting with S.

I want to be able to select which column I search.

It sounds like if it is possible to search more then one column at the time?

**rorya** · 03-01-2019, 07:48 AM

There are numerous examples already on the forum of filtering listboxes - for example: https://www.excelforum.com/excel-pro...-list-box.html

**waimea** · 03-01-2019, 08:10 AM

Hi rorya,

thank you for your reply! I am looking at your link and I almost got it working!

**waimea** · 03-01-2019, 08:50 AM

I think I understand the code for the sorting in your link.

However, I don't understand how to filter on values such as "> 1000" or "> 10000"?

**waimea** · 03-01-2019, 11:43 AM

I think I need to use autofilter?

Can someone show me how to filter a listbox.list/array with a textbox?

How to read table in an array and populate a listbox with the array

LinkBack

Thread Tools

Rate This Thread

Display

How to read table in an array and populate a listbox with the array

Re: How to read table in an array and populate a listbox with the array

Re: How to read table in an array and populate a listbox with the array

Re: How to read table in an array and populate a listbox with the array

Re: How to read table in an array and populate a listbox with the array

Re: How to read table in an array and populate a listbox with the array

Re: How to read table in an array and populate a listbox with the array

Re: How to read table in an array and populate a listbox with the array

Re: How to read table in an array and populate a listbox with the array

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Read Table Headers to Array

[SOLVED] Populate one array from another array and print new array as a range

[SOLVED] Can't populate an array with selected items from listbox

Loop new messages containing a table, populate a dynamic array, paste array to Excel

[SOLVED] Read last element of Split array and then discard it and resize the array.

[SOLVED] Populate Listbox with all rows of a dynamic array where elements of a single array match.

VBA - Can I populate a listbox from an array taken from a listview selection

Bookmarks

Bookmarks

Posting Permissions