Want current date to autopopulate a textbox

  • Thread starter Thread starter Bishop
  • Start date Start date
Hi Bishop

Try the below. You can choose the event..to suit your requirement

Private Sub UserForm_Activate()
Me.TextBox1 = Format(Date, "dd-mmm-yyyy")
End Sub

If this post helps click Yes
 
Back
Top