I think this question has been asked a million times, so I apologize if this is the 1,000,001. I have searched and searched, and have followed soo many topics on this, with no results to get passed my error, so I am finally asking for help through the forums.
So we are trying to do some basic tracking on what the employees are packing on a daily basis. So I thought it should be easy enough to make a userform to help with data input, and keep the data clean.
So far I have a descent userform setup.
- Name of person, only select able to the ones who can pack, so no wrong names can be inserted.
- Date is auto done, but not so great it puts up the date. as long as you type something then the date appears.
- Our sku format, we call VPS so the products are VPS and a 5 digit number VPS01010, and I named this textbox VPSNumber. This is where I am having a problem. The check to see if the VPSnumber is valid works great. But trying to figure out how to autopopulate the other labes like price and product description alarms out where I bolded the code.
Any help would be greatly appreciated.
Bookmarks