AfterUpdate with DTPicker Control

[terryw]

Does anyone know how to make the AfterUpdate event work with the DTPicker control? It is availible as an option, but it appears to do nothing.

My problem is that I want to be able to use the dtpicker OR manually input the date and not have any code run until after the update is made.

If I use the change event only, code runs each time a user manipulates the calander... this is pretty annoying. Also, if I use the the CloseUp event, the calander works great but the code does not run when dates are input manually.

Last, I would prefer not to use the Exit event, since I need my code to run as soon as an update is made with the control.

In a nutshell, the AfterUpdate event would be perfect....if it would only work.

Can anyone help?

 

[sunnyland]

Hello there,

You could go as follow:
Meaning when the user click enter the code run.
If you go this way don't put a linked cell value
Put some code in the keydown event


Private Sub DTPicker1_KeyDown(KeyCode As Integer, ByVal Shift As Integer)
'key enter pressed
If KeyCode = vbKeyReturn Then
'your code
'range("a15")=dtpicker1.value
End If
End Sub

 

[terryw]

Thanks! I will give that a try.