Hi members here, we have problem to key-in data entry with almost 1000+ different part into single sheet, I'm planning to use userform to find part number and fill it into each cell,
main point is, search criteria value is combobox dropdown list is listed from Part Number in column B , if user enter value and value is same in the list , Part Name Tool Number and Customer Name automatic show into each textbox as named and disable (greyed) cannot edit, then user key-in Qty Output numbers only and Date is numbers of day 2 digit, Save button is for fill Qty Output below number of date (column F:AJ) then clear all textbox and dropdown to key-in another Output.
2nd point is, IF Part Number is not in the list, user enter the new Part Number at (Combobox dropdown) and key-in all data (cannot empty, except Qty Output and Date), and save data to next last of cell column B and clear or empty the textbox for the next key-in.
the table I'm using Table Format, column A is autonumbering (=ROW()-3)
thank you.
main point is, search criteria value is combobox dropdown list is listed from Part Number in column B , if user enter value and value is same in the list , Part Name Tool Number and Customer Name automatic show into each textbox as named and disable (greyed) cannot edit, then user key-in Qty Output numbers only and Date is numbers of day 2 digit, Save button is for fill Qty Output below number of date (column F:AJ) then clear all textbox and dropdown to key-in another Output.
2nd point is, IF Part Number is not in the list, user enter the new Part Number at (Combobox dropdown) and key-in all data (cannot empty, except Qty Output and Date), and save data to next last of cell column B and clear or empty the textbox for the next key-in.
the table I'm using Table Format, column A is autonumbering (=ROW()-3)
thank you.