You don't need to add any code to be able to select a date. There should be
a calendar that pops up when you click the down arrow. If that's not working
I don't know what is wrong. The only thing I can think of is that you need
to make sure you aren't in design mode. The code that comes up when you
click the control in design mode is fine. It's just a shell for adding code.

there is another calendar control "Calendar Control 9.0" . It basically does
the same thing except the calendar stays visible, it doesn't hide after you
select a date.
--
Billy Rogers

Dallas,TX

Currently Using Office 2000


"Shorty" wrote:

I have tried to link the control to a cell, It shows the date in the
linked cell which is great. Though for some reason i still can not
change the value in the date box. I have linked it to a cell, set min
and max dates and enabled the check box. here is the code i get when
double clicking on the date box

Private Sub DTPicker1_CallbackKeyDown(ByVal KeyCode As Integer, ByVal
Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)
End Sub

Should be some more code in here?