I have an application I am trying to help a coworker complete. We use 150 to 200 "bulk item codes" for process paramater specifications.
What she would like to do is to create a userform to pick the 10 to 20 bulk item codes produced for the day and enter the production units.
Say the spreadsheet looks like:
A B
Bulk Prdtcn
1 Item Units
2 1400051 15,243
3 1400118
4 1400139 9,386
5 1400228
6 1400230
7 1400231 11,236
8 1400232
9 1400236
10 1400290
11 1400401
12 1400404 7,235
13 1400406
14 1400411
she would like to be able to enter the bulk item code (not let her enter an item that is not in the above list) and the corresponding production units into a userform that would look like:
Bulk Prdtcn
Item Units
1400051 15,243
1400139 9,386
1400231 11,236
1400404 7,235
I have been trying to read the VBA Help file on using the ListBox without much success.
Is the ListBox the correct tool, and if so, how do I use it in this application?
Bookmarks