ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Want current date to autopopulate a textbox (https://www.excelbanter.com/excel-programming/430281-want-current-date-autopopulate-textbox.html)

Bishop

Want current date to autopopulate a textbox
 

How do I make the current date autopopulate in a textbox in my userform?

Jacob Skaria

Want current date to autopopulate a textbox
 

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
---------------
Jacob Skaria


"Bishop" wrote:

How do I make the current date autopopulate in a textbox in my userform?



All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com