Hello,
I have designed a user form that a supervisor will enter data from a daily production operation. I have tried to make it as user friendly as possible for them. The supervisor only will need to enter the "Item number" which will look up data in another workbook and populate some of the other txt boxs on the form. He will enter a value in a text box (txtItem) on the userform and have it return a value in the other text boxs in the userform (txtProduct), (txtProC), and (txtOpt).
Currently I have a spread sheet that will do a vlookup within the worksheet but I wold like to have this all happen within the userform.
Can anyone show what the code would be do the same operations in a userform.
Below is my Vlookup formula within the worksheet.
Product;(txtProduct)
=IF(B4="","",VLOOKUP(B4,'\\Owensrv\owen\Management Projects\Plant Governance\[Rate Lookup Tool.xls]North'!$A:$D,2,FALSE))
Product Cat; (txtProC)
=IF(B4="","",VLOOKUP(B4,'\\Owensrv\owen\Management Projects\Plant Governance\[Rate Lookup Tool.xls]North'!$A:$D,4,FALSE))
Optimal; (txtOpt)
=VLOOKUP(E4,'\\Owensrv\owen\Management Projects\Plant Governance\[Rate Lookup Tool.xls]North'!$F:$I,4,FALSE)
Thank you
I have designed a user form that a supervisor will enter data from a daily production operation. I have tried to make it as user friendly as possible for them. The supervisor only will need to enter the "Item number" which will look up data in another workbook and populate some of the other txt boxs on the form. He will enter a value in a text box (txtItem) on the userform and have it return a value in the other text boxs in the userform (txtProduct), (txtProC), and (txtOpt).
Currently I have a spread sheet that will do a vlookup within the worksheet but I wold like to have this all happen within the userform.
Can anyone show what the code would be do the same operations in a userform.
Below is my Vlookup formula within the worksheet.
Product;(txtProduct)
=IF(B4="","",VLOOKUP(B4,'\\Owensrv\owen\Management Projects\Plant Governance\[Rate Lookup Tool.xls]North'!$A:$D,2,FALSE))
Product Cat; (txtProC)
=IF(B4="","",VLOOKUP(B4,'\\Owensrv\owen\Management Projects\Plant Governance\[Rate Lookup Tool.xls]North'!$A:$D,4,FALSE))
Optimal; (txtOpt)
=VLOOKUP(E4,'\\Owensrv\owen\Management Projects\Plant Governance\[Rate Lookup Tool.xls]North'!$F:$I,4,FALSE)
Thank you