Searching the web for a VBA solution for creating a calendar, I found one on a Microsoft site (http://support.microsoft.com/kb/150774).
Their solution has a very laborious way to place the numbers into the calendar grid.
Here is my simpler solution.
Microsoft's code:
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by dangelor; 12-14-2011 at 12:12 AM. Reason: repair code display
According to the ISO system, december 2011:
Please Login or Register to view this content.
Last edited by snb; 12-15-2011 at 04:19 AM.
snb,
Your code places a date in the cells, not the day number, and fills every cell. My code (and Microsoft's) will only populate those cells that correspond to the actual days of the current month with the day number.
I don't see a question in the original post. If you are sharing your updated code (which I thank you for), please add an example workbook so we can see the results. Also this thread is probably better for the Water Cooler rather here. You can PM one of the moderators to move it.
Hope this helps.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
As suggested, attached is a simple calendar using code. Change the selections in the drop down cells to create calendar.
Please Login or Register to view this content.
in the attachment:
- the use of 2 validationlists (see macro snb how they are being attributed)
- the use of a worksheetevent
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks