Data Entry VBA Form

mishdo1

New Member
Joined
Sep 20, 2006
Messages
19
I am seeking some assistance from you intelligent people out there. I am working on creating a data entry system that will capture general customer data and then scanned data. I am capturing customer general information on one worksheet and the scanned data (serial numbers) on another worksheet with the customer data and execution dates (At this point Customer Name is primary key). With that in mind, I am trying to figure out how to setup the form designed for the Serial Number scan (capture) to allow multiple entries in Visual Basic.

Flow of forms 'Customer Setup' -> 'Project Information' -> 'Serial Number Entry'. Project Information and Serial Number Entry are going to populate the same worksheet. I will need the information from Project Information form to copy for each Serial Number scanned. So how I do I program the Serial Number entry form to allow multiple scans (Scanning appears to work just like keying in numbers and hitting enter key) and populate individual cells/row?
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,122,521
Messages
5,596,653
Members
414,083
Latest member
Mrsash

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