title: Start with empty dtPicker Value, then change format after pressing sumbit button
body: <p>I've really struggled with this one, I've browsed through Google but not found a working solution for me. This is the case (using US Office 2016 and added the mscomct2.ocx);</p>
  
  <p>Loading the Excel also loads UserForm1.
  Within this, I have a 'DateFrom' and 'DateTo' using the DateTimePicker.</p>
  
  <p>At startup I would like both to show empty (using checkbox is not an option). After choosing the appropriate 'DateFrom' and 'DateTo' the presented format in the UserForm is .dtpLongDate (set from the dtPicker properties box).</p>
  
  <p>When pressing the submit button, I need the DateTimePicker format to change from .dtpLongDate to Custom format "yyyy-MM-dd" so I can put the DateFrom.Value into a string which needs this specific format.</p>
  
  <p>I've tried everything I've found, but as I'm quite novice on VB, nothing I've tried seem to work.</p>
  
  <p>This is the code I have in the start of the command button:</p>
  
  <pre><code>Private Sub CommandButton1_Click()
  
  Dim i As Integer
  Dim TerminalIDRange As Range
  Dim ii As Long
  Set FormlerSheet = Worksheets("Formler")
  Set DataSheet = Worksheets("Data")
  Set TerminalIDRange = DataSheet.Range("M2:M2000")
  
  DateFrom.Format = DateTimePickerFormat.Custom
  DateTo.Format = DateTimePickerFormat.Custom
  DateFrom.CustomFormat = "yyyy-MM-dd"
  DateTo.CustomFormat = "yyyy-MM-dd"
  
  MsgBox DateFrom.Value
  </code></pre>
  
  <p>Still the DateFrom.Value show me date as dd.mm.yyyy for some reason.</p>
  
  <p>Also; to set code for the DateFrom and DateTo to be blank after loading the UserForm, where do I place this code??</p>
  
  <p>Hope somebody can help me on this...</p>