How to Make the First Issue of the Past Month Appear as (26) which was on Monday
publicado
Hello everyone from Maurizio
My problem is this .
I'm trying but failing to want to create some sort of Calendar
Slo that my problem with the vba is this:
in a userform I inserted a Textbox and Seven Labels, of which 6 are classified as (Cella1,Cella2,Cella3) etc...!
And I want them to stay that way.
While a label the name has remained unchanged and is called (Label3)
Now what I would like to get from vba code, and that every time I start the userform the Labels classified as (Cella1 etc ...! the number "26" is reported which corresponds to the number of the month of December which was (Monday ) and gradually all the other ends to reach (1) of the following week which corresponds to the Number of the beginning of this month.
In addition, if it were possible, I would like to be able to make the start date of the month appear in (Label3) as a code, as I manually reported, to better understand "01/01/2023"
Clearly if I change the date in the Texbox these data must be able to change accordingly.
I don't expect you to do all the work for me It would be enough for me
just to see the Number (26) appear in the label (Cella1) and the start date of the month in (Label3)
Thank you
Greetings from A.Maurizio
Hello everyone from Maurizio
My problem is this .
I'm trying but failing to want to create some sort of Calendar
Slo that my problem with the vba is this:
in a userform I inserted a Textbox and Seven Labels, of which 6 are classified as (Cella1,Cella2,Cella3) etc...!
And I want them to stay that way.
While a label the name has remained unchanged and is called (Label3)
Now what I would like to get from vba code, and that every time I start the userform the Labels classified as (Cella1 etc ...! the number "26" is reported which corresponds to the number of the month of December which was (Monday ) and gradually all the other ends to reach (1) of the following week which corresponds to the Number of the beginning of this month.
In addition, if it were possible, I would like to be able to make the start date of the month appear in (Label3) as a code, as I manually reported, to better understand "01/01/2023"
Clearly if I change the date in the Texbox these data must be able to change accordingly.
I don't expect you to do all the work for me It would be enough for me
just to see the Number (26) appear in the label (Cella1) and the start date of the month in (Label3)
Thank you
Greetings from A.Maurizio
Numero_Setimana_Inizio_Mese.xlsm