Combobox selection to find specific ID and allow data entry on that row

Hey guys, I'm working on developing a userform to simplify our data entry. The information is proprietary so I cannot attach a copy of the spread sheet alone. So i'll try and explain the best I can.

I have a userform that allows me to enter the data I need onto the sheet I need, all works fine. However, the information I'm entering is basic product information.
I am adding a second userform (possibly a third) to enter process specific data. So in short, in this form I will be adding a textbox. In this textbox the user will enter a "load ID". At that point Im thinking I need to add a cmd button to start the search for the entered ID under column F:F. Once the ID has been located, there will be additional text boxes and comboboxes where we will enter the data we're recording. I need the data we are entering to be added to the specific row where that "load ID" is located.

It would also be nice if I can add a list box at the bottom showing particular cells that contain existing product specific information. That way the user knows for sure he is entering the data for the right "Load ID"

There will also be instances where multiple rows contain the same "Load ID", in this case, I will need that data being entered to populate in all rows containing that "Load ID" in column F:F.

I hope this was specific enough, please let me know if you need more clarification on what im looking for.

** Almost forgot, when searching for the load ID if the cells that the textboxes are associated with already contain values then I would like to see those values. That way we can see whats filled out already and whats not. Thanks guys! hope you are all safe and healthy in these rough times we're in.

This assumes the button is Active-X and installed on the same UserForm as the TextBox where the search criteria will be entered.

Please Login or Register  to view this content.

You can use this for a template and modify it according to the comments I have entered. I wouold name the text boxes and the command button so there is no mistake about which one does what. The code goes in the UserForm code module.