I have a form with a combo box that is populated with a range of dates from a row in excel.
For i = 1 To rngDates.Cells.Count
.AddItem Format(rngDates.Cells(i).Value, "dd mmmm")
i = i + 5
.ListIndex = 0
This works fine but I was wondering....
Is it possible to use the inbuilt 'calender control 8.0' in excel VBA to do this, but make it so only the dates in my worksheet are available to choose from. Maybe make the other dates greyed out?
Thanks for any help