Preselected month should be filled out automatically.

Hi,

I have a sheet where I've inserted a list with months. I would like to set it up so that upon selecting a certain month, it fills out all days of that month somewhere else in the same sheet.

I hope this is enough of an explanation for people to be able to help me.

Kind regards,

Zjak

First of all, thanks for the quick reply.

Unfortunately it ain't exactly what I was looking for. I want to have all the dates of a certain month (so far your answer was excellent), but it would be for only one (preselected) month. Ideally, the dates given would change if the user would select a different month from the scrolldown menu I created.

I can PM you a screenie if that would help you with this problem. Eventhough I did take a VB for Excel course, I'm still quite inexperienced.

Regards,
Zjak