VBA Excel Provide current Date in Text box

Question

I have a dialog box that appears when the user clicks a macro button   This dialog box is mostly filled out  date  email  producer  website  etc are filled  and all the user needs to do is enter their name   The problem is that the date entered is static  so if I entered  3 3 11  it ll stay that way until someone changes it     I was wondering if there was some way for that text box to always display the current date  unless the user decides to change it for whatever reason    I ve tried putting different things into the  Value  section of the text box  such as  getDate    and    Date     but so far haven t been successful   Thank you   Jesse Smothermon

User · Answer

Here s a more simple version   In the cell you want the date to show up just type        Today           Format the cell to the date format you want and Bob s your uncle

User · Answer

Actually  it is less complicated than it seems   Sub    today 1     ActiveCell FormulaR1C1     TODAY      ActiveCell Value   Date End Sub

User · Answer

Set the value from code on showing the form  not in the design-timeProperties for the text box    Private Sub UserForm Activate       Me txtDate Value   Format Date   mm dd yy   End Sub

User · Answer

I know this is extremely old post  but I ve used this before  You can always adjust to activate  Now method is another way  Just an option  Private Sub UserForm Initialize    Textbox1 Text   Format Now     mmddyyyhhmmss    End Sub

User · Answer

You were close  Add this code in the UserForm Initialize   event handler   tbxDate Value   Date

User · Answer

The easy way to do this is to put the Date function you want to use in a Cell  and link to that cell from the textbox with the LinkedCell property   From VBA you might try using   textbox Value   Format Date    mm dd yy

User · Answer

Use the form Initialize event  e g    Private Sub UserForm Initialize       TextBox1 Value   Format Date   mm dd yyyy   End Sub

[excel] VBA Excel Provide current Date in Text box

Examples related to excel

Examples related to vba

Examples related to date

Examples related to textbox