+ Reply to Thread
Results 1 to 5 of 5

Form is submitting as text instead of a date format

  1. #1
    Registered User
    Join Date
    12-18-2021
    Location
    Norway
    MS-Off Ver
    365
    Posts
    3

    Form is submitting as text instead of a date format

    Hello,
    I have made a form trying to submit fields to an excel sheet. I have formatted the excel coloumn as date, but the form is submitting the date as text into the date field making the sheet useless.
    Any help will be appreciated.

    The actual field:
    Please Login or Register  to view this content.
    The whole form:


    Please Login or Register  to view this content.
    Last edited by Reffo; 12-18-2021 at 12:47 PM.

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

    Re: Form is submitting as text instead of a date format

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-18-2021
    Location
    Norway
    MS-Off Ver
    365
    Posts
    3

    Re: Form is submitting as text instead of a date format

    Thank you, but can you please give me a hint where to place it in my code? Tried allmost everything.

  4. #4
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,163

    Re: Form is submitting as text instead of a date format

    Controls of type TextBox and ComboBox store values as text. Therefore, when moving values from controls to worksheet cells, you must enforce the appropriate data type. In the case of ComboBox3, this is the date, so
    Please Login or Register  to view this content.
    If TextBox3 is to be a number, then
    Please Login or Register  to view this content.
    Artik

  5. #5
    Registered User
    Join Date
    12-18-2021
    Location
    Norway
    MS-Off Ver
    365
    Posts
    3

    Re: Form is submitting as text instead of a date format

    Thank you very much Artik! This solved my case!

    Best regards,
    Trond

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Submitting date from one sheet to another
    By DingaBell in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-17-2020, 07:09 AM
  2. Fill in form on website and submitting multiple values in new tabs
    By vojo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2015, 07:27 AM
  3. Submitting an HTML Form, then accessing the new results tab, error 424: Object Required
    By keith-burns in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2014, 02:34 PM
  4. Submitting web form resets the form
    By lynn00lynn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2014, 02:09 PM
  5. On submitting form, automatically go to next blank row.
    By mynameismichael in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2014, 04:08 PM
  6. Putting Spreadsheet Into Date Order After Submitting Userform
    By stuu3270 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2013, 08:38 AM
  7. Submitting web form (cannot target submit button)
    By carlofardella in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2013, 11:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1