Want current date to autopopulate a textbox

J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

userform textbox returns changeable date 4
populate dropdown/combobox on userform with specific values from s 3
HELP: What is wrong with my For loop 4
Access Dateadd function question.. 0
How to autopopulate column w/May using a col w/ 05/15/07(Excel)? 1
Auto Populate Combo Box When Opening a Worksheet 2
Code to select cells with data 1
restrict textbox on userform to mm/yyyy 1

Top