Sort of an Excel calendar

[hobgoblin]

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

[MWE]

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]

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]

.

[Ken Puls]

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]

Okay, should have read Bob's first.

Nice work! :thumb

[hobgoblin]

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: