ComboBox to filter Listbox Data

**TommyMurphy** · 12-06-2018, 08:49 AM

Please note that this question has also been posted here: mrexcel.com/forum/excel-questions/1079976-combobox-filter-listbox-data.html
(Unable to post link due to forum rules)

Good morning all!

I am pretty much a newbie but reasonably adept at adapting code (or bludgeoning my way through until I manage to somehow get things working!)

I am having trouble getting a userform listbox to filter based on combobox selection. To be honest, I dont even know where to begin with making this work..

My Code is as follows:

Please Login or Register  to view this content.

The list box is called: "List of Data"
The Combo I want to use to filter the data is "ComboBox7"
The data for the Listbox is stored on "Sheet1"
Im looking to be able to filter on Row B of the data in sheet 1 (which is Column 2 of the listbox)

Any help would be greatly appreciated!!

If it helps, I can also post the workbook.

Thanks
Tom

**mehmetcik** · 12-06-2018, 07:25 PM

You have renamed your controls.

This makes your coding inefficient.

Rule 1. Never Rename your controls, It makes Coding Harder

Please Login or Register  to view this content.

The above code enters the numbers 1 to 100 in textboxes 1 to 100
How would you do that if each Textbox has a unique name?

Rule 2. Number Each Control with the Column Number of its Source Data.

Please Login or Register  to view this content.

The above code loads Textboxes 1 to 100 with the data in row 1, columns 1 to 100

Please Login or Register  to view this content.

The above code Stores Textboxes 1 to 100 in row 1, columns 1 to 100

Rule 3. You can have more than one control storing data to the same cell or
reading data from the same cell

That is not a problem. As long as they are not the same type of control.

Eg. Textbox1, Combobox1, Label1 can all read / write to the same cell

Rule 4. Rule 3 Simplifies Writing data from your controls to your worksheet

Please Login or Register  to view this content.

Rule 5. Rule 3 Simplifies Loading data from your worksheet to your controls

Please Login or Register  to view this content.

Rule 6. Speed Up Your Userform by Reducing the Number of Times You Read or Write to Excel.
Write Your Data into an Arrray and Write the Array to Excel.

Writing Data to Worksheet using An Array.

Please Login or Register  to view this content.

Rule 7. Speed Up Your Userform by Reducing the Number of Times You Read or Write to Excel.
Read your data from Excel into an Arrray and then copy the data into your controls.

Reading Datafrom Worksheet using An Array.

Please Login or Register  to view this content.

Rule 8. Use the Titles On your Spreadsheet as the default text for your Controls

Please Login or Register  to view this content.

**Kyle123** · 12-07-2018, 02:41 AM

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**Kyle123** · 12-07-2018, 02:57 AM

Xposted on mrE

**TommyMurphy** · 12-12-2018, 05:13 AM

Originally Posted by Kyle123

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi Kyle123.

Apologies for the late reply, I have been away on holiday!

Many thanks for the advice, I will work through my project & improve as per your suggestions.

I have attached a sample of the workbook. It is currently working as I need with the exception of a combobox filter. Any help in getting this to work would be greatly appreciated.
The filter needs to work on column 2 of the listbox.

Many thanks for your help this far.

Tom

**Kyle123** · 12-12-2018, 05:26 AM

Your post does not comply with Rule 3 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Please make sure to include the full link, so that other members will be permitted to continue helping you

Note that if you have fewer than 10 posts, you may need to type the link, or past it in pieces (or ask a mod to do that for you)

**TommyMurphy** · 12-12-2018, 05:36 AM

Hi Kyle123.

Apologies, I am new to forums & did not understand this rule. Would I be best to delete the other post or link it here?

**Kyle123** · 12-12-2018, 07:31 AM

Just add a link to the first post

**TommyMurphy** · 12-12-2018, 07:45 AM

Originally Posted by Kyle123

Just add a link to the first post

Link added. Again, apologies for the error

**TommyMurphy** · 01-02-2019, 12:23 PM

Ok, I managed to get it working. For anyone interested or having the same problem, this is how I did it:

Please Login or Register  to view this content.

**Kyle123** · 01-02-2019, 12:25 PM

You could also use this: https://www.excelforum.com/tips-and-...e-listbox.html

ComboBox to filter Listbox Data

LinkBack

Thread Tools

Rate This Thread

Display

ComboBox to filter Listbox Data

Re: ComboBox to filter Listbox Data

Re: ComboBox to filter Listbox Data

Re: ComboBox to filter Listbox Data

Re: ComboBox to filter Listbox Data

Re: ComboBox to filter Listbox Data

Re: ComboBox to filter Listbox Data

Re: ComboBox to filter Listbox Data

Re: ComboBox to filter Listbox Data

Re: ComboBox to filter Listbox Data

Re: ComboBox to filter Listbox Data

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Filter ListBox based on ComboBox selection

[SOLVED] UserForm ComboBox Filter ListBox Display

Search/Filter from multiple combobox to a listbox

Filter UserForm Multicolumn ListBox with TextBox/ComboBox

Checkbox, optionbutton or combobox to filter listbox

Using ComboBox on Userform to filter ListBox

[SOLVED] Filter a listbox with a combobox and seach button

Bookmarks

Bookmarks

Posting Permissions