Date Time Picker problem!!

[Paco75]

Hi,

I'm using a DTPicker Object in my Excel macro and something weird happens when I select a date... it opens another form I got in my project!!! And I really don't understand why since there is no code at all in this object!!


thanks

 

[RobBroekhuis]

Have you tried to shut down Excel and start up again? When strange stuff happens, that's my first line of defense...
Rob

 

[Paco75]

Yes, and I even rebooted the PC... but the problem is still there!

 

[RobBroekhuis]

Could you show how you're using it?
Rob

 

[Paco75]

I put no code in the events of the DTPicker! What do you want to know?

 

[RobBroekhuis]

What is the code that calls/uses the DTpicker?
Rob

 

[Paco75]

In a button to write a text file i got these lines:

If Len(CStr(AdminDate.Value)) > 0 Then
f.Write " 100 " + CStr(AdminDate.Value) + vbCrLf
Else
f.Write " 100 " + vbCrLf
End If

in another button that clears the form I got this:

AdminDate.Value = CStr(Date)

in a button to read a text file containing data:

If strNoChamp = "100" Then
MultiPage1.Value = 1
AdminDate.Value = CDate(strValeur)
End If

 

[RobBroekhuis]

The redirection to the other form happens when you manually pick a date? Strange. I wonder if it's something about your Excel configuration (mine has quirks as well). If you'd like me to test on my side, feel free to send your workbook over (with instructions on how to reproduce the behavior). broekhrr@apci.com
Rob

 

[Paco75]

no it's ok I simply stop using DTPicker in that project... since it forced me to install excel .ocx and it finally don't work well in my PC. I use text box and spinbuttons instead.

thanks