how to change the value of DTPicker

**jay11** · 03-19-2010, 01:41 PM

hi
pl help on changing the property of "DTPicker" as u can see it's 3/18/2010 instead of this it should display Today's date
thanks in advance

**dominicb** · 03-19-2010, 01:55 PM

Good afternoon jay11

Originally Posted by jay11

pl help on changing the property of "DTPicker" as u can see it's 3/18/2010 instead of this it should display Today's date

Replace your Initialize routine with this piece of code :

Code:

Private Sub UserForm_Initialize()
    Me.CombTicker.RowSource = "Ticker"
    Me.txtcommission = 7
    DTPicker1.Value = Now()
End Sub

HTH

DominicB

**jay11** · 03-19-2010, 01:58 PM

thanks DominicB
that was quick as always

Thread: how to change the value of DTPicker