Selected Answer
Hi Edward,
I have used VBA to add the selected items to the "Data Sheet" in C3:C12. Items are selected one at a time. As items are added to the "Data Sheet" the count goes up. If the count reaches 10 a message box pops up to indicate the max has been reached and nothing more happens (nothing more gets added). On the "Signs" sheet I added an information line to let the user know how many items have been picked. I also added an information area to indicate what the currently selected item is. I also added a button to clear the list on the "Data Sheet".
This could also be achieved using a UserForm instead of a ListBox.
The attached file shows the changes have made.
Hope this helps; if so, please mark my answer as Selected.
Cheers :-)