EXCEL USERFORM- pull data from sheet 1 into userform
Currently all data entered into the userform goes into Sheet 3.The user scans a barcode into the field txtMaterial. A list of material numbers is located in Sheet 1 column AB. The next field on the user form is txtBin. The bin numbers are located also on Sheet 1 column AC. Is it possible when the barcode is scanned into the txtMaterial field have code that will locate that number on Sheet 1 column AB , when found have the corresponding data in Sheet 1 column AC insert into the user form under the txtBin field. So from looking at the example below when txtMaterial scans barcode labeled 50100000000000R the txtBin field would show up on the userform as well have Sheet 3 as D5. I have attached my Workbook.
Material No Bin Location
Re: EXCEL USERFORM- pull data from sheet 1 into userform
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1