+ Reply to Thread
Results 1 to 10 of 10

UserForm - Display todays date

  1. 11-15-2011, 02:05 AM #1
    stojko89
    stojko89 is offline
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    UserForm - Display todays date

    Hi

    I have a UserForm thats like some order template. And I'm tryin to figure out what to use so it would display todays date. So when you call the UserForm it would have a Label or I don't know what to use that would display the date, couse later when he would hit send the order it copys the date to locked cell so he can't change the date later so he can't cheat
    They keep changing the date so I don't realy know later witch is the right date of the order.
    And they can't be able to change the date in the UserForm.
    Help please?
    Last edited by stojko89; 11-15-2011 at 03:32 AM.
    Reply With QuoteRegister To Reply
  2. 11-15-2011, 02:20 AM #2
    optomyst
    optomyst is offline
    Registered User
    Join Date
    11-03-2011
    Location
    Shelton, CT
    MS-Off Ver
    Excel 2010
    Posts
    67

    Re: UserForm - Display todays date

    Can you attach your workbook?
    Reply With QuoteRegister To Reply
  3. 11-15-2011, 02:25 AM #3
    stojko89
    stojko89 is offline
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: UserForm - Display todays date

    Sure

    Button Novo Naročilo calls the UserForm and where it says Datum Naročila and theres an empty white box Label there should be todays date. I hope you u understand.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 11-15-2011, 02:50 AM #4
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: UserForm - Display todays date

    Maybe this. In the form frmNovoNarocilo module.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 11-15-2011, 03:32 AM #5
    stojko89
    stojko89 is offline
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: UserForm - Display todays date 

    Please Login or Register  to view this content.
    I used this but your little hint worked great I changed the Label to a txtBox so I change the code to this and it works great.

    Thank you very much for your time!
    Reply With QuoteRegister To Reply
  6. 11-15-2011, 03:47 AM #6
    stojko89
    stojko89 is offline
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: UserForm - Display todays date

    @nilem

    Do you maby know if there's a way to change the format of the date?

    Currently is like this 11/15/11 it is the todays date but since I'm use to the other format of date is it possible to make it look like this 15.11.2011 ?
    Reply With QuoteRegister To Reply
  7. 11-15-2011, 03:48 AM #7
    stojko89
    stojko89 is offline
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: UserForm - Display todays date

    now the format is month/day/year i would love for it to be day.month.year
    Reply With QuoteRegister To Reply
  8. 11-15-2011, 03:51 AM #8
    stojko89
    stojko89 is offline
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: UserForm - Display todays date

    Sorry.

    Forget I asked, couse I just saw that it's the right format on the sheet
    Reply With QuoteRegister To Reply
  9. 11-15-2011, 03:52 AM #9
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: UserForm - Display todays date 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 11-16-2011, 01:38 AM #10
    stojko89
    stojko89 is offline
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: UserForm - Display todays date

    Thank you again!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1