entering data from userform and fill value into cell

nalsur

New Member
Joined
Jan 29, 2012
Messages
14
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

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,564
Messages
5,770,886
Members
425,649
Latest member
cbTexas

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
Top