Hello everyone my name is Maurizio.
And my new probema and this: Using a Userform I created a calendar and so far nothing interesting.
Now, however; I wish that every time I open my Calendar; See Photo 1:
All the numbers that make up the calendar month you could also set in Sheet 1 starting from cell A3: G8.
Almost like herself that timetable had been contriuto also on the sheet 1.
While in reality: and only a shift of all the numerical data that are located within the label.
And his final result would be as shown in Figure 2:
That's all. Thank you
(P.s) However even enter my test project
Hi,
I'm not entirely sure what you are trying to do. But I looked at your workbook and I'm guessing you are trying to get the calendar in your form to take the dates from the worksheet?
Why don't you look at this post which has working code to display a calendar in a form. You can change dates in the calendar and use the chosen date to populate a cell etc. This calendar is implemented as a class.
https://www.myonlinetraininghub.com/excel-date-picker
Alternatively you can read this post where the calendar is implemented as a MonthView control
https://www.myonlinetraininghub.com/excel-forms
This post guides you through inserting data onto a sheet, so you can take the date and put it where you want to,
https://www.myonlinetraininghub.com/excel-forms-insert-update-delete
Regards
Phil
Hello Philip Treacy, thanks for your technical support, but what I would do and I simply understand itself is the ability to copy only those numbers that make up the calendar nell'userform created inside the spreadsheet cells from the current cell (A3: G8) that's all I want nothing more.
Steps should be:
1) I open my Calendar dell'userform.
2) Prelovo only Numeric data that make up the monthly calendar; As for example: "1, 2, 3, 4, 5" etc ...!
And I transfer them into the sheet 1.
Without further codes, that's all.
You can do you get all this thanks
Hi Maurizio
Your calendar on the userform is not accurate as the complete days are not shown. I did not modify this for you as I don't understand your codes.
I have only added a module to put the correct dates on the worksheet based on the date in the INSERIRE UNA DATA field (ignoring your calendar).
You can try the attached file. Just press the ESTRAI button after you change the date in the INSERIRE UNA DATA field.
Sunny
Hello SunnyKow thank you as always for your help and technical support.
But how you will have well visualized this topic for me had been closed because I did not succeed in realizing what I really wanted.
For here, since you made me understand that my basic request could not be made for practical reasons.
I thought well of Going Over and simply adopting your first advice as a concrete help to take the creation of an Image of a Working Calendar directly on the Sheet and then print it on an Image.Picture called by my Userform.
And beautiful anyway; But that was not what I wanted.
Anyway you want you can Download and take a look at my last post called (Regalino or down there)
You can find them in my Program made and finished in all its parts; Or even better you can download it directly from this link:
Https://app.box.com/s/oqolkok7w2i2h8zdbf4udukfu4j3wyc0
Thanks Infinite for All Sincere Goodbyes and Good Weekend
