Dynamic multiple entry using a userform - noob

[johnhirschi]

I need to build a userform that allows my users to enter either a work order number or inspection lot number for a dynamic number of serial numbers. When the form initiates, it needs to get a list of serial numbers (strings), then allow the user to enter a work order number or inspection lot number. Since these numbers are indistinguishable, I need to have two different places to allow entries for each serial number, either a work order number or an inspection lot number.

I used my best google-fu and searching here, but I'm a complete newbie when it comes to userforms. I don't know what control I should be trying to use. Here is my toolbox:

image.jpg

I don't have the "Microsoft Office Spreadsheet" that used to be included. What control should I be using? I was hoping to build something like this:

image2.jpg

I appreciate any help you can give me!

Thanks!

[mikerickson]

If you use two text boxes, the user can type in the WorkOrder or InspectionLot that they desire.

If you want to restrict their choices, a ListBox or ComboBox would be options.