DTpicker value 0

**shardin** · 11-03-2012, 05:13 AM

Hi,

I have inserted a Date and Time Picker on a userform so that the user can choose a date and then populate it to a cell on a worksheet.

The code is as follows:

Private Sub CommandButton1_Click()
Unload Me
Dim FechaAsiento As Date
FechaAsiento = DTPicker1.Value
Windows(ThisWorkbook.Name).Activate
Range("D3080") = FechaAsiento
End Sub

The problem that I have is that the value entered in D3080 is always zero, no matter what the chosen date is.

Any help?

**Sindhus** · 11-03-2012, 05:54 AM

Move "Unload Me" before End sub or before activating the sheet. That could be the problem. If this is not solving your problem, Please upload a sample workbook.

**shardin** · 11-03-2012, 03:16 PM

Well, yes, but the problem is that after the code that I put, there is other part of the code, in which another userform is shown (a progress bar). I have to unload or hide the current form so that the progress bar is shown, otherwise I get error 104 "Can't show a non modal userform while a modal userform is shown. This can be solved however if I change the showmodal property of the main userform to True. But I don't know what consecuences this may have...

**FDibbins** · 11-03-2012, 04:00 PM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here