Content of a Textbox populates a ComboBox

[Scubaru]

I started with a new company a few months ago on a project where we are transitions the entire company from the old parts inventory system that was independent to a global system linking all 18 locations.

Already we have an Excel userform that I created that allows us to search by either the old inventory systems dummy number or the part number. The issue is the part number entry needs to be exact to what I copied from the plants database (ie. if the plant used # 345-D-997 and the stamped part number is #345 D 997 no result will display). The way I would like to approach this is a textbox that users can enter a portion of the number, this would then populate a combobox with the matches that contain the entry. I however don't have the slightest idea how to begin programming that. Can anyone shed some light on how to best achieve this?

I have included the code I'm currently using. My skills in VBA are very entry level and I'm afraid what I'm asking to achieve might be a bit above my head but I really would like to get something going. On average we are sorting through less than 1,000 parts if that matters for the type of code I can use.

3a.jpg

Please Login or Register  to view this content.

[mehmetcik]

What you ask is quite simple.

I would help if you had posted a workbook.

Failing that the attached shows you how to do it:-

Type dal into one textbox, ch into the second ro into the third.

Please Login or Register  to view this content.

[gmr4evr1]

If I am understanding correctly, you can use just the combobox as this will populate the closest match as the user types in the combobox. You can also have the combobox automatically have the list of data in it for the user to select and set the combobox property to Match.

Can you attach a sample workbook of what you have with the UserForm and code you are using, along with a sample list that you want in the combobox?

[gmr4evr1]

Looks like mehmetcik came up with a solution.

[Scubaru]

Can I ask why am I typing "dal" "ch" and "ro" into the text box's?

I have also included a snip of the workbook, I don't know how to upload the entire workbook on here simply.

Thank you!

What you ask is quite simple.

I would help if you had posted a workbook.

Failing that the attached shows you how to do it:-

Type dal into one textbox, ch into the second ro into the third.

Please Login or Register  to view this content.

10.JPG

[mehmetcik]

That shows you how the code works.

Then you can modify it.

[Scubaru]

Scratch what I originally posted, so I have it working now that it returns values to either my Listbox or ComboBox. Problem is I can't clear the old values with my "Clear" Button. Thoughts?

The other issue is I've managed to get the code to populate either a combo box or list box with the appropriate results. I've trying to run the same code I used for the first search box which I have an example of below. I am guessing since both of these boxes are dynamic in that they are showing results and now running off of a manually entered value. What would be the best way to populate my fields with the results?

This is my code currently. I've tried both when you use the combobox dropdown you highlight your selected part and hit enter, no luck. Then I tried you highlight your selected part and use the "Go" button to fire the code to run on that selected part, it keeps bugging out.

Please Login or Register  to view this content.