+ Reply to Thread
Results 1 to 7 of 7

Dates are transposed using fill in form

  1. #1
    Forum Contributor
    Join Date
    11-14-2004
    Location
    Watford, England
    MS-Off Ver
    Microsoft Office 365
    Posts
    129

    Dates are transposed using fill in form

    Hi All,

    I am using this VBA code to get data from a fill in form to populate a table.
    Please Login or Register  to view this content.
    This populates the sheet fine except row P,Q,S and U. These are all dates.

    When I enter the date in the fill in form for example 11/09/2017 it will change it to 09/11/2017 on the sheet if the column is formatted as date, but if it is formatted as text it will stay as 11/09/2017.

    I tried this.
    Please Login or Register  to view this content.
    But still the same.

    Thanks
    Last edited by fastcar; 10-20-2017 at 04:35 PM. Reason: Solved

  2. #2
    Registered User
    Join Date
    10-12-2017
    Location
    Brazil
    MS-Off Ver
    2016
    Posts
    59

    Re: Dates are transposed using fill in form

    Good afternoon.
    I usually use the value2 property of the range object when the data type is date.
    See if the attachment helps you
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    11-14-2004
    Location
    Watford, England
    MS-Off Ver
    Microsoft Office 365
    Posts
    129

    Re: Dates are transposed using fill in form

    Quote Originally Posted by gfranco View Post
    Good afternoon.
    I usually use the value2 property of the range object when the data type is date.
    See if the attachment helps you
    Thanks for the reply.
    I see that imports the info from the sheet to the form but my issue is the other way round. I type the date in the form but it does not write it correctly on the sheet, it I type 11/09/2017 on the form it writes 09/11/2017 on the worksheet.

    Cheers.

  4. #4
    Forum Contributor
    Join Date
    11-14-2004
    Location
    Watford, England
    MS-Off Ver
    Microsoft Office 365
    Posts
    129

    Re: Dates are transposed using fill in form

    To make things easier I have added the file here.

    If you click "Update Edit - Driver Details" on the "Menu" sheet it brings up a fill in form, if you select driver B for example then click "find details" it will pull up his details
    fine, but when you click "Update details" and then "Find Details" again the DD and MM of the date keep getting transposed.

    I have formatted the columns as Date.

    Thanks for the help.
    Attached Files Attached Files

  5. #5
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Dates are transposed using fill in form

    How about this ?

    Please Login or Register  to view this content.
    PS your Column U is formatted as Text.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  6. #6
    Registered User
    Join Date
    10-12-2017
    Location
    Brazil
    MS-Off Ver
    2016
    Posts
    59

    Re: Dates are transposed using fill in form

    Good evening.
    Here with me it worked perfectly, but I noticed that some dates were formatted as text in your spreadsheet. In doubt, I've formatted all columns of entire dates as date and it's working fine here with me. My default date system is DD / MM / YYYY

  7. #7
    Forum Contributor
    Join Date
    11-14-2004
    Location
    Watford, England
    MS-Off Ver
    Microsoft Office 365
    Posts
    129

    Re: Dates are transposed using fill in form

    Quote Originally Posted by bakerman2 View Post
    How about this ?

    Please Login or Register  to view this content.
    PS your Column U is formatted as Text.
    Thanks worked fine.

+ 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. Pre fill a form Txt box with infromation form a WS cell
    By OillyBob55 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-18-2017, 08:30 AM
  2. Pasting data from OCR text subjected Adobe file; the dates seem to have transposed; this
    By PivotTablePSHomage in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2017, 06:01 PM
  3. Replies: 9
    Last Post: 09-16-2015, 08:45 PM
  4. Replies: 3
    Last Post: 02-09-2012, 06:57 PM
  5. Replies: 1
    Last Post: 05-27-2010, 12:32 PM
  6. Auto Fill Web Form using Excel User Form
    By vandanavai in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2008, 02:26 AM
  7. [SOLVED] Fill in form to type Item descrictions and costs and fill in funct
    By cradino in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-16-2006, 03:45 PM

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