Creating an Auto-Fill Order Form

Not sure whether it a sensible way or not.
The attached is restrictive i.e.,you have to be disciplined to enter your data in blocks of five, as per existing.
If this is acceptable then the listbox is self maintaining and expands as you add data and the code should also cope with reading in from the data table.
Note, the listbox no longer uses the rowsource, it is loaded by the UserForm_Initialize event.
torachan.

Hi, Thanks for that. I've had a look at it again and come up with the attached. We have Technical specifications that the customer would usually use to communicate their requirements. So I've decided to utilise these for the ordering.

It still needs refinement though, so any help would be greatly appreciated.

Al