title: Show current time (EST)
body: <p>I created a UserForm that contains a textbox that will show the current time in EST. The only problem is, the time that's reflecting is of course the current time in our country so I want to convert it in EST, which is <code>- 12:00</code> from our time. </p>
  
  <pre><code>Private Sub UserForm_Initialize()
  If ActiveWorkbook.MultiUserEditing Then
  
  End If
  
  Application.ScreenUpdating = False
  Application.DisplayAlerts = False
      txtDate.Value = Format(Now, "mm/dd/yyyy")
  
  
  Application.ScreenUpdating = True
  Application.DisplayAlerts = True
  End Sub
  </code></pre>