View Full Version : [SOLVED:] Sort of an Excel calendar
hobgoblin
08-17-2005, 01:33 PM
Ok guys, first of all i want to say that i've searched alot on the web and didn't find anything, so i'm asking it here : pray2: :
How do i create a calendar in excel? I want to choose lets say a month in 1 cell, and in the cells under it will show the mondays of that month.
Here is an example:
OCTOBER NOVEMBER DECEMBER FEBRUARY MARCH APRIL
3 10 17 24 31 7 14 21 28 5 12 19 26 6 13 20 27 6 13 20 27 3 10 17 24
So when user chooses october from a dropdown list it will automatically show the mondays of this month in the cells under it, move other cells accordingly, etc.
:help
Ok guys, first of all i want to say that i've searched alot on the web and didn't find anything, so i'm asking it here : pray2: :
How do i create a calendar in excel? I want to choose lets say a month in 1 cell, and in the cells under it will show the mondays of that month.
Here is an example:
OCTOBER NOVEMBER DECEMBER FEBRUARY MARCH APRIL
3 10 17 24 31 7 14 21 28 5 12 19 26 6 13 20 27 6 13 20 27 3 10 17 24
So when user chooses october from a dropdown list it will automatically show the mondays of this month in the cells under it, move other cells accordingly, etc.
:help
there are lots of Excel calendar templates floating around. Is there something special you wish to do that makes all of them not what you want?
hobgoblin
08-17-2005, 01:50 PM
Yup. none of them seem to use a drop down list of months, and i didn't see any that adds and move cells accordingly, etc. But most important, the list is made through Data-Validation-List, so i don't know where do i put the custom function that i will create so it runs only when i use this drop down list. That is my main problem. The function, i can write it myself, it's not that hard. the hard part is to make it run ONLY when a user select a month from a drop down list. :dunno
help? Anybody?
Bob Phillips
08-17-2005, 02:30 PM
.
Ken Puls
08-17-2005, 02:34 PM
Matt Vidas put a calendar template together a while ago which you may want to try...
See here (http://www.vbaexpress.com/forum/showthread.php?t=1740&highlight=calendar)
Don't know if it suits exactly for your purposes or not.
Think I'll check out Bob's now. :)
Ken Puls
08-17-2005, 02:35 PM
Okay, should have read Bob's first.
Nice work! :thumb
hobgoblin
08-18-2005, 07:14 AM
Tnx Guys. It's pretty close to what i'm trying to acheive. :joy: The rest i'll try to do myself. :creator: Can't just put it all on your shoulders :D
P.S. Will mark it solved when i'm done. :whistle:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.