+ Reply to Thread
Results 1 to 3 of 3

VBA Code for a "Today's Date" box in a userform?

  1. #1
    Registered User
    Join Date
    03-02-2012
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    11

    VBA Code for a "Today's Date" box in a userform?

    I am new to VBA and am in no way any kind of computer programmer. I get by with my basic knowledge of Excel most of the time, but VBA programming is beyond my level of expertise.

    I would like to create a text box for collecting dates, and I would like to have a "Today's Date" button autofill the field in the userform.

    Please consult the screenshot (screencap.png) if there is any confusion as to what I'm after. I appreciate any help, I'm really stuck and this frankly isn't my cup of tea.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    re: VBA Code for a "Today's Date" box in a userform?

    Assuming the text box is TextBox1 and the command button is CommandButton1 then give this a go.
    Place this in the command button.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-02-2012
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    11

    re: VBA Code for a "Today's Date" box in a userform?

    Wow, that was even easier than I would have ever imagined. Thanks, Dave!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1