Is there any function in Excel to m

[bnageshrao]

Is there any function in Excel to make a date drop down box appear so that users can scroll through the calendar to pick up mm/dd/yyyy.

 

[ide]

if you have a combobox on a userform:

Private Sub UserForm_Initialize()
Dim i As Double
Dim StartDate, EndDate As Date
StartDate = DateSerial(2001, 1, 1): EndDate = DateSerial(2001, 6, 1)
For i = Int(StartDate) To Int(EndDate)
ComboBox1.AddItem Format(i, "mm\/dd\/yyyy&quot
Next i
End Sub

ide (-: