+ Reply to Thread
Results 1 to 9 of 9

Geting headick to Format(Now, "dd.mm.yyyy hh:mm") inside a userform textbox!

  1. 01-30-2014, 05:38 AM #1
    Reemet
    Reemet is offline
    Registered User
    Join Date
    06-27-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2007
    Posts
    49

    Geting headick to Format(Now, "dd.mm.yyyy hh:mm") inside a userform textbox!

    Hello guys!

    I will thank You all in advance!

    I have trouble to format value as a date & time!
    I have used many different things but nothing works!

    i want use now and format it to the "dd.mm.yyyy hh:mm" inside UserForm TextBox! Later i use it to calculate time in side the sheet!

    BR

    Reemet
    Reply With QuoteRegister To Reply
  2. 01-30-2014, 05:45 AM #2
    perimidt
    perimidt is offline
    Registered User
    Join Date
    11-26-2013
    Location
    Norway
    MS-Off Ver
    Excel 2013
    Posts
    67

    Re: Geting headick to Format(Now, "dd.mm.yyyy hh:mm") inside a userform textbox!

    Hi

    Your format appears to be correct, have you used it this way?
    TextBox1.Value = Format(Now(), "dd.mm.yyyy hh:mm")
    Best regards

    Per Erik Midtr?d
    Reply With QuoteRegister To Reply
  3. 01-30-2014, 05:50 AM #3
    Reemet
    Reemet is offline
    Registered User
    Join Date
    06-27-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2007
    Posts
    49

    Re: Geting headick to Format(Now, "dd.mm.yyyy hh:mm") inside a userform textbox!

    ---------------------------
    Microsoft Visual Basic
    ---------------------------
    Compile error:

    Wrong number of arguments or invalid property assignment
    ---------------------------
    OK Help
    ---------------------------
    Reply With QuoteRegister To Reply
  4. 01-30-2014, 05:54 AM #4
    perimidt
    perimidt is offline
    Registered User
    Join Date
    11-26-2013
    Location
    Norway
    MS-Off Ver
    Excel 2013
    Posts
    67

    Re: Geting headick to Format(Now, "dd.mm.yyyy hh:mm") inside a userform textbox!

    Hi

    I don't know why that it. Any chance you can upload your file?
    Reply With QuoteRegister To Reply
  5. 01-30-2014, 06:09 AM #5
    Reemet
    Reemet is offline
    Registered User
    Join Date
    06-27-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2007
    Posts
    49

    Re: Geting headick to Format(Now, "dd.mm.yyyy hh:mm") inside a userform textbox!

    Yes

    Location

    FormI
    Code
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 01-30-2014, 06:47 AM #6
    perimidt
    perimidt is offline
    Registered User
    Join Date
    11-26-2013
    Location
    Norway
    MS-Off Ver
    Excel 2013
    Posts
    67

    Re: Geting headick to Format(Now, "dd.mm.yyyy hh:mm") inside a userform textbox!

    Hi

    I see that it is in fact not working, but I really don't see why
    Reply With QuoteRegister To Reply
  7. 01-30-2014, 07:08 AM #7
    Reemet
    Reemet is offline
    Registered User
    Join Date
    06-27-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2007
    Posts
    49

    Re: Geting headick to Format(Now, "dd.mm.yyyy hh:mm") inside a userform textbox!

    I don't get it also!
    If anyone get the clue, then would be nice to get to know it!

    BR
    Reply With QuoteRegister To Reply
  8. 01-30-2014, 11:39 AM #8
    Reemet
    Reemet is offline
    Registered User
    Join Date
    06-27-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2007
    Posts
    49

    Re: Geting headick to Format(Now, "dd.mm.yyyy hh:mm") inside a userform textbox!

    Its impossible

    Gives error and vba don't know what to do with Format!
    All things i have found in web wont work!

    If anyone get the point then let me know!



    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 02-11-2014, 10:29 AM #9
    Izandol
    Izandol is offline
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Geting headick to Format(Now, "dd.mm.yyyy hh:mm") inside a userform textbox!

    In module2 you have routine called Format - you must change name or remove this. Or you may use VBA.Format in the userform code.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules
    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)

Similar Threads

  1. sumif based on year value from column with dates in "mm/dd/yyyy" format
    By Willardio in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-27-2013, 04:58 PM
  2. [SOLVED] Convert from "general" (YYYYMMDD) to specific "custom" format (YYYY.MM.DD)
    By Ella_p in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2013, 02:23 AM
  3. [SOLVED] Excel glitch? (Userform Textbox = Format, "Date")
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-13-2013, 01:47 PM
  4. [SOLVED] UserForm - TextBox = Format("yyyy/mm/dd")
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2013, 12:16 PM
  5. Macro-Highlight cells in column D if the date format is other than "mmm-dd-yyyy hh:mm:ss"
    By mani88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2013, 06:25 AM

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