UserForm Search - Find the product when typing the ID

Since you are populating only a single record on UserFom, I guess you need ComboBox instead of TextBox.
In ComboBox, you can select existing IDs from column L to populate the relevant records on the Form Controls.
I have inserted a ComboBox on the UserForm, see if that works for you otherwise you can delete it.
There is a code underneath the Go button so that when you type and ID in TextBox and click the Go button, all the controls will be filled with the relevant information.

Remove the existing codes from the UserForm Module and place the following codes in there.

Please Login or Register  to view this content.

That's pure art! Exactly what I need. The ComboBox is actually a very good option, but as I will be having over 4000 ID's of products I will sometimes need to just enter the code and have the characteristics appear. Many thanks for that.

Just one question, if the ID is only numbers, the information won't show. Is there a way for macro to accept only numbers, numbers and text or text as my ID?

Second question, in my file I have 2 companies (and I will have a third one) which I would like to compare and find matching products in order to compare prices. Company 1 products are my base to compare (or by just typing certain characteristics I want directly into the UserForm. How hard would it be that if I click on "Search" the Macro will find those characteristics in Company 1 products (B7:M30) Company 2 products (B33:O100) and Company 3 (B102:Q"x") and show the results in a separate worksheet?

Will it also work that if I only type into the UserForm lets say, 120 in Voltage TextBox and 60 in Wattage TextBox as my values and click search, I will have in the next sheet all products that contain those values?

I hope I'm explaining myself correctly.

Thanks again.

Well it looks like a project instead of just a question and honestly I don't have that much of time to address all those points as I am busy in my project.
So what I would suggest you that you rephrase your question systematically and open a new thread and provide the relevant sample data and code you are currently working with so that other experts would be able to help you to resolve all the issues you are having.

But since I answered your original question so before opening a new thread, don't forget to mark this thread as Solved.