User Form Date picker Calculation

[homevest]

Hello,

Having trouble with a user form I am building.

What I am trying to accomplish is a calculation to auto show in textbox1 the number of days between today and what is entered in datepicker1 - even when datepicker 1 is at default of today.

Thank you,

 

[DanteAmor]

Try this

Private Sub DTPicker1_Change()
  TextBox1 = DTPicker1.Value - Date
End Sub


Private Sub UserForm_Activate()
  TextBox1 = DTPicker1.Value - Date
End Sub