Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Months and Dates
Hi, im looking to enter the Months of the year into a combo box, whic
is what i have done .....but can any one please help me on how to ge the dates according to that month to show up underneath, so that i ca have a timesheet according to the relevant month.. e.g Jan, 31 days, i list of dates... etc etc Thankyou -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Months and Dates
Hi
see your post in Excel.misc -- Regards Frank Kabel Frankfurt, Germany Hi, im looking to enter the Months of the year into a combo box, which is what i have done .....but can any one please help me on how to get the dates according to that month to show up underneath, so that i can have a timesheet according to the relevant month.. e.g Jan, 31 days, in list of dates... etc etc Thankyou. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Months and Dates
Here's some code
Private Sub ComboBox1_Change() Dim i As Long Dim dteCombo As Date Range("A1:A31").ClearContents For i = 1 To 31 dteCombo = DateSerial(Year(Date), ComboBox1.ListIndex + 1, i) If Month(dteCombo) = ComboBox1.ListIndex + 1 Then Cells(i, "A").Value = dteCombo Else Exit For End If Next i End Sub -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "adn4n " wrote in message ... Hi, im looking to enter the Months of the year into a combo box, which is what i have done .....but can any one please help me on how to get the dates according to that month to show up underneath, so that i can have a timesheet according to the relevant month.. e.g Jan, 31 days, in list of dates... etc etc Thankyou. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Months between two dates | Excel Discussion (Misc queries) | |||
Months between two dates | Excel Discussion (Misc queries) | |||
Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
Need More Help on Dates to Months | Excel Worksheet Functions | |||
Dates to months and calculating values for their months | Excel Programming |