Ok, I used your recent file, and updated it try to show you what I am trying to accomplish...the real world setting. I have copied all the following information to the workbook in the "Log" worksheet so you can read it while you are looking at the layout. I have made some alterations but I have tried to explain everything.
I originially wanted to have 2 userforms, one with text boxes & one with combo boxes. To enter the information for column's D and E, "Employee Name" & "Production #'s" respectively. After thinking about it, I guess just one userform using comboboxes (for the employee name) will work the best, as I can enter the "unit" information manually on this page without too much hassle and doing that will also assist in making sure I am entering it correctly.
The reason I want combobox's is that I am working with 90 employees in this instance, and some names being foreign, need to have a "-" in a certain spot, and everything has to be typed correctly or I will not be able to sort the data properly, which is currently my number one issue. So I moved the "UniqueDateList" to column S, and created a "NameList" in column T, where I can input all the current employees and call this information to the comboboxes.
*Note: I tried to use the Data Validation List function, but it doesn't help as the list is extremely long, and it will not finish what you start typing, so it is not efficient. For illustrative purposes, See cell D2.
*This is why having that "recall" feature is really valuable, because often employees are in the same spot, but not 100% of the time, as people call off, are moved to other lines, quit, vactaion, etc.
The rest of the sheet is going to be calling information from other workbooks (columns F-R), so that information will not have to be put on the userform. So my biggest hurdle right now will be comboboxes.
I have added another userform "UserForm2" with comboboxes to this workbook, but the code will not work as it is from your initial worksheet, not even the updated code. But I believe I have the labels named properly as you have previously mentioned.
*also I added a Reset button, but the code I used will not work, so I erased the code, any ideas how I can have this clear the form?
Bookmarks