Design a Plain Monthly Calendar

Using VBA, How to Design a Plain Monthly Calendar - I

Dear Forum,

I want to create Monthly Calendars by selecting on any of the cells in a particular Column..
This Monthly Calendar would be a Matrix of the following :

1st Row -- the Month Name and the Year
2nd Row - Week nos , Sun, Mon, Tue, Wed, Thu, Fri, Sat
3rd Row - Week No , The Actual Dates spread in Smaller Matrix of 6 X 7 Cells..

Please find the Attachment...

Warm Regards
e4excel

Hi,

There is a question about "reinventing the wheel" that comes up now than then. I'm wondering why the standard calendar control that comes with office isn't good enough?

http://answers.microsoft.com/en-us/o...4-e9e058c88df7

Thanks a Lot Marvin P, I was looking fo this for a long time but never could find anything as such for my other Projects..

In this Project, I still require a Personalised MOnthly-Calendar, infact I have a further requirement and thus the name of my query is "I" as I need to incorporate the Holidays and Reminders in the calendar on those specific dates...

Very Difficult to support my decision in having the Personlaised Calendar as the design of entering the Dates is still in nascent stage..

But with the Holiday Data it will be imperative to have a Customised Calendar..

Nevertheless, the one given in your link is fantastic and I am surely using it for all my other files..

Please pardone me for the same...

Regards
e4excel

Hi e4excel,

I tried to build my own userform calendar control in about 1993 using Access. I put a bunch of small command buttons on a userform and renamed them so they fit with the correct month and year and weekdays. I must have spent a month working on this userform. Then I found MSCal that was an add-in control. It went through a few revisions and had some possible securtiy leaks in it so was dropped in 2007 (if I remember right). I was pleasently suprised to find a new calendar control in Access 2010.

I've also found generic calendar userforms on the web but realize things change and I want to stick to the Microsoft Standard, so I haven't followed the topic much lately.
See http://answers.microsoft.com/en-us/o...9-e757223ebdde or
http://www.fontstuff.com/vba/vbatut07.htm which is what I thnk you really want.

Hope this keeps you from writing your own when you can stand on others sholders.

Hi e4excel,

I forgot to mention the DTPicker tool that was created to do the same thing in my above links.

http://www.bigresource.com/VB-DTPick...As2sZzZfJ.html

Dear Marvinp,

Thanks for all the Wonderful lInks but can you or someoneplease still help me on the code which I was trying to write...

Also, in the Last Links Date Picker the Todays Date is shown below next to a Red Lasso Mark, can you please telll me how can we make that ?

I need a Calendar which can actually display even Holidays in the Calendar Itself, if you check my File-Attachment theres a Hidden Sheet to display the Holidays or Payment Dates and even Birthdays in the Calendat itself, if I can see all these things whe I am entering the date whichever way it will be quite helpful,isn't it?

Warm regards
e4excel

can someone guide me on my formula plzzzzzzzzzz..

Please Login or Register  to view this content.

Please Login or Register  to view this content.

is incorrect actually I want to say that the first line should get executed when the code is getting ebtered the first time in the cell C4,D4,E4,F4,G4.H4 and I4 and then for the next set of 7 rows it should be the Else Formula..

Hi,

We'd love to solve your problem for you. The problem I have is to understand your problem. It looks like you check a range named target in the If statement above. If the target is on row 4 then it passes this test and moves to the next line of code. Then you only want to do this next line of code if C4 to I4 are blank? Is that the question?

To test for C4 to I4 all being blank how about using a Length of the concatinated string being zero?

If that isn't the real question then, could you be more clear on the requirements.

Thanks.

Thanks MarvinP...

I would be adding an attachment this time which I couldnt do earlier on account of bad internet connectivity..

I have actually goofed up in the Logical Part, I need to populate the calendar from the cell C4 till I9 this is my Actual Range where the Calendar Dates should appear...

As I am no good in VBA I was trying something which was working via Formulas..but faltered on the Target Portion which I realized later...

I was actually trying to put a Fixed Code for the First Row where the Data starts gettting populated which is the Row = 4 as it starts from Cell C4 till I4 and then it moves to the next Row = 5 i.e. C5 till I5 so on so forth..

But I dont have an idea of putting the code for such a thing I think my File would do the needful in terms of an explanation ,....

Actually, I need two calendars one would be a simple Calendar for this Project and another would be the Same Calendar with Holidays and Important Dates Embedded in the Calendar itself...

All the Links which you gave are extremely useful infact I liked the very first one itself but I need to also Add the Holidays..

After receiving a solution if the need be I can start a New Thread..and therefoe I have named the Query as Part-I...

Warm Regards
e4excel