Okay I'll amend to only allow for one order to be entered in any one day.

As regard comboboxes or list boxes instead of textboxes, yes it is possible, but are they really needed?

In my opinion this project would be much better using worksheets, and a minimum amount of VBa, instead of a User Form, that way would be much easier and faster and you could have as many drop-down list as you want.

Can't do more tonight, look back tomorrow late on (say after 20:00 GMT)