Dear Experts,
When a value entered in Textbox1, it searches the data in a closed worksheet and return the result. If Textbox1 value is product, Textbox2 return the description of product. Let the workbook contains data remain closed. There will be 2 workbooks. Workbook1 will have the userform and there will be another workbook holds all the datas.
Kindly help
When a value entered in Textbox1, it searches the data in a closed worksheet and return the result. If Textbox1 value is product, Textbox2 return the description of product. Let the workbook contains data remain closed. There will be 2 workbooks. Workbook1 will have the userform and there will be another workbook holds all the datas.
Kindly help