entering data from userform and fill value into cell

nalsur

New Member
Joined
Jan 29, 2012
Messages
21
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
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.

data_entry.PNG
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Forum statistics

Threads
1,213,562
Messages
6,114,322
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top