PDA

View Full Version : DTPicker has gone AWOL ???



Rlb53
02-05-2012, 09:15 PM
Has anyone has a DTPicker go AWOL before ?

I've got two DTPicker commands.
Each in separate userforms.
Both Userforms are within the same workbook.
Each DTPicker is named DTPicker1 and DTPicker2 respectively.

One of them works fine. The other repetetively returns a value of "0".

I have Closed the Workbook, Opened the Workbook, Deleted the failing DTPicker and Reinstalled it. Each, Numerous times.

Any Thoughts? Thanks !

p45cal
02-06-2012, 12:38 AM
Is the DTPicker on a multipage control?

Rlb53
02-06-2012, 12:39 AM
Negative. The two DTPickers in the workbook are on independant userforms.

p45cal
02-06-2012, 12:44 AM
can you attach a workbook with the fault?
what version of excel?

Rlb53
02-06-2012, 02:56 AM
Thank you p45!

I wanted the DTPicker to establish the day / time that the action was taken within the workbook. I have circumvented it by establishing a cell with the @now() command, then incorporating a secondary command to copy the value of the cell to the appropriate location.

I'ved moved on from this malfunction... and will try the DTPicker in some other workbooks to see if the problem persists when I get the chance.

Thank you for your response and offer !