Currently trying to improve an Excel app I've written for use at work. As-is, user runs the app activated from the plant production schedule, enters the production date, clicks "Continue" and the app goes through the production schedule, finds the needed data for each production line's paperwork, then the user has to create the Inbound number in SAP and place the correct Inbound number in each line's worksheet before printing the paperwork.
I'm trying to cut down on errors by along with setting up the line worksheets, but also updating the individual production line data fields in the userform, leaving the userform open and visible for user to copy the P.O. Number from the userform, paste it into SAP to create the Inbound, then key in the SAP created Inbound Delivery number into the Inbound Number field on the userform, then be able to click the userform "Complete" button and have it automatically place the Inbound Delivery number into the production line worksheet with no risk of the individual user accidentally changing the wrong areas of the production line worksheet resulting in wrongly formatted output getting printed for the production line.
I've been unable to get the userform textbox entries to change and have found nothing telling me how to do it, but I've used other apps with such update/multi-use userforms used, so I know it's possible to do.
I'm trying to cut down on errors by along with setting up the line worksheets, but also updating the individual production line data fields in the userform, leaving the userform open and visible for user to copy the P.O. Number from the userform, paste it into SAP to create the Inbound, then key in the SAP created Inbound Delivery number into the Inbound Number field on the userform, then be able to click the userform "Complete" button and have it automatically place the Inbound Delivery number into the production line worksheet with no risk of the individual user accidentally changing the wrong areas of the production line worksheet resulting in wrongly formatted output getting printed for the production line.
I've been unable to get the userform textbox entries to change and have found nothing telling me how to do it, but I've used other apps with such update/multi-use userforms used, so I know it's possible to do.