UserForm ask

[something]

Hi guys

I am a new member of the forum and happy to tell you hello. Do not speak / write good English so I apologize.

I had to do a small program to store for vegetables in Excel 2003.

I made a table in which to enter data for products sold every day. /see table1.jpg/
Field "Products" will be filled with information for accepted supplies.I made a UserForm /see UserForm.jpg/ to describe the supply.

I want to find a way to save filled UserForm being saved with a name which is the number and date of delivery in the form /see example.jpg/.

Accept any advice on program. If necessary i upload the excel file.

Best regards!
Miroslav

[royUK]

You cannot save a userform, the data entered needs to be saved to a worksheet

[something]

Thanks for the reply!
Please suggest a solution!. How should I structure the program?
Is there any option?

[royUK]

The pictures don't help. Attach a workbook

[something]

The pictures don't help. Attach a workbook

Done!

My idea is to monitor deliveries and sales everyday. Button "delivery accept" provides information about the products delivered and put them in cell "Product" in sheet1.
Cell "sold" shows the quantity sold per day and entered manually, and the price in cell "price". When i click "finish day" must be passed to the next day, without any quantity sold of the previous day.

I need and to generate some reports:
1. Sold for the day;
2. Took delivery of day and month;
3. Sold for months;

I am grateful for any suggestions and any ideas!
I hope I explained correctly!