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.
Bookmarks