Userform - coding the button

[jamescatton]

Firstly, thanks to jmthompson who helped me with my previous query. I now have a new query, and wasn't sure whether to repost in that thread, or start a new, specific thread. I hope this is ok.

I am trying to set up an excel spreadsheet to keep track of glasses that I loan out, and to make sure we don't go over our stock.

I have created a userform, for the first time, which allows the user to select a "date out" and a "return date". And then you can select how many trays of the 4 different types of glasses to order.

What I'd like to know now, is how to make excel input this data into the spreadsheet on the click of a button in the userform. Hope this makes sense.

Any help you can provide would be much appreciated.

 

[rguy84]

How would you enter multiple orders a day, but know that these 4 go with order 1 and those 2 with order 2?

 

[jamescatton]

Sorry about that long break - had to go into work. Everyone seems to think my idea is good, but hopefully it'll work.

I'm less bothered about knowing which orders go with which customer on the computer, because we can keep paper records for that. The excel thing is just to ensure we don't over-do it again.