Need help with calendars...PLEASE HELP!

[Shaka215]

Hey,

Over the last week I have been trying to get an answer to my
problem...

am in need of a worksheet that will display all the days in a month
in one column based on the values selected in two drop down boxes.
These two drop down boxes will be obviously the month and the year. The

reason why I can't just use the normal VB calendar plug-in is because
even using a date in one cell I end up with the months that have either

more then 28 days or 31 days in it so its not a matter of having a date

in cell A1 and having 29 more cells underneath of it with the value of
=SUM(A1+1) because if it is February the first few days of March would
be displayed. I need the spreadsheet to just display only the days that

are in a month and not display the date in the next month. I need the
drop down boxes to work with displaying only the days in a particular
month and the ability to not show dates in the next month...

1.) Drop down boxes to allow the end user to select a month and year (I

can do this part).
2.) All the dates in one column (this I cant figure out)
3.) Only showing dates in the month selected from the drop down boxes

I have provided an example...please take a look and let me know if you
can
figure it out. If you do figure it out how to do this I would be very
grateful and
if you could...please e-mail it to my e-mail address Shaka215 at
gmail.com
Thanks so much! The web address to the workbook is here...

http://www.toddsherman.biz/cal.zip

I tried to make it as less complicated as possiable. The example isn't
the working model but if you can get it to work using what I have
provided I should be able to figure out your logic...I've been
scratching my head over this one for alittle over a week now...who knew

end-users would be so damn picky? Much appreciated!

Any help is much appreciated!!! Thanks!

NickHK - I tried to use the code you supplied but its returning a
"#VALUE!" error.

 

[PaulD]

I will email you the file but this worked for me

Sub Update()
Dim i As Integer
Dim myMonth As Integer
Dim myYear As Integer
Dim myDate As String

Range("B2:B32").ClearContents
myMonth = [T21]
myYear = [U22]
For i = 1 To 31
myDate = myMonth & "/" & i & "/" & myYear
If IsDate(myDate) Then
Cells(i + 1, 2).Value = myDate
End If
Next i
End Sub

Paul D

: Hey,
:
: Over the last week I have been trying to get an answer to my
: problem...
:
: am in need of a worksheet that will display all the days in a month
: in one column based on the values selected in two drop down boxes.
: These two drop down boxes will be obviously the month and the year. The
:
: reason why I can't just use the normal VB calendar plug-in is because
: even using a date in one cell I end up with the months that have either
:
: more then 28 days or 31 days in it so its not a matter of having a date
:
: in cell A1 and having 29 more cells underneath of it with the value of
: =SUM(A1+1) because if it is February the first few days of March would
: be displayed. I need the spreadsheet to just display only the days that
:
: are in a month and not display the date in the next month. I need the
: drop down boxes to work with displaying only the days in a particular
: month and the ability to not show dates in the next month...
:
: 1.) Drop down boxes to allow the end user to select a month and year (I
:
: can do this part).
: 2.) All the dates in one column (this I cant figure out)
: 3.) Only showing dates in the month selected from the drop down boxes
:
: I have provided an example...please take a look and let me know if you
: can
: figure it out. If you do figure it out how to do this I would be very
: grateful and
: if you could...please e-mail it to my e-mail address Shaka215 at
: gmail.com
: Thanks so much! The web address to the workbook is here...
:
: http://www.toddsherman.biz/cal.zip
:
: I tried to make it as less complicated as possiable. The example isn't
: the working model but if you can get it to work using what I have
: provided I should be able to figure out your logic...I've been
: scratching my head over this one for alittle over a week now...who knew
:
: end-users would be so damn picky? Much appreciated!
:
: Any help is much appreciated!!! Thanks!
:
: NickHK - I tried to use the code you supplied but its returning a
: "#VALUE!" error.
: