Hello to all my name I am Maurizio and I am a New Member.
My problem with this using excel office 2007 I created a perpetual calendar using a userform.
Now I have to admit that: Everything works fine, except for one fact that I can with all my good will to solve.
And my problem is this: I would that changing the date is in Txt.Anno TXTMese in which the number of the current month of Yellow colorasse opening dell'userform.
Some of you would know me out about Thanks.
Sincere greetings from A.Maurizio
Why not try something like the sheet I have attached. I set up two cells with =NOW() and =NOW()+1 and then conditionally formatted the range of cells I wanted to use to highlight cells in yellow who's value is between the two =NOW cells. I had to do that because =NOW() runs to the microsecond so a straight if A=B then wouldn't work.
Have a look a see what it looks like.
Hi Rufus46 I am new to the Forum for here I don't know where to put their hands, For here please would you be so kind to tell me where it went to finish your Program that you'd Annex Thanks greetings from a. Maurizio