Results 1 to 25 of 25

Check Date Format Input into Excel Column with VBA code ("DD/MM/YYYY" format)

Threaded View

inoka Check Date Format Input into... 12-11-2017, 04:11 AM
ranman256 Re: Check Date Format Input... 12-11-2017, 10:08 AM
inoka Re: Check Date Format Input... 12-11-2017, 11:40 PM
inoka Re: Check Date Format Input... 12-11-2017, 11:48 PM
inoka Re: Check Date Format Input... 12-12-2017, 01:31 AM
ikboy Re: Check Date Format Input... 12-12-2017, 04:11 AM
inoka Re: Check Date Format Input... 12-12-2017, 04:30 AM
jindon Re: Check Date Format Input... 12-12-2017, 06:31 AM
inoka Re: Check Date Format Input... 12-12-2017, 08:07 AM
jindon Re: Check Date Format Input... 12-12-2017, 08:14 AM
inoka Re: Check Date Format Input... 12-12-2017, 11:17 PM
jindon Re: Check Date Format Input... 12-12-2017, 11:20 PM
inoka Re: Check Date Format Input... 12-13-2017, 07:28 AM
inoka Re: Check Date Format Input... 12-13-2017, 07:43 AM
jindon Re: Check Date Format Input... 12-13-2017, 07:48 AM
inoka Re: Check Date Format Input... 12-14-2017, 12:42 AM
jindon Re: Check Date Format Input... 12-14-2017, 12:54 AM
inoka Re: Check Date Format Input... 12-14-2017, 02:54 AM
jindon Re: Check Date Format Input... 12-14-2017, 03:15 AM
inoka Re: Check Date Format Input... 12-14-2017, 04:20 AM
jindon Re: Check Date Format Input... 12-14-2017, 04:29 AM
inoka Re: Check Date Format Input... 12-14-2017, 07:42 AM
jindon Re: Check Date Format Input... 12-14-2017, 08:30 AM
jindon Re: Check Date Format Input... 12-14-2017, 07:58 AM
inoka Re: Check Date Format Input... 12-14-2017, 08:26 AM
  1. 12-12-2017, 01:31 AM #5
    inoka is offline
    Forum Contributor
    Join Date
    12-11-2017
    Location
    Colombo
    MS-Off Ver
    2013
    Posts
    109

    Re: Check Date Format Input into Excel Column with VBA code ("DD/MM/YYYY" format)

    If I add date as "2019-09-12", it is shown a debug error. Could you please help me to find this error.
    Also, if I add "10/25/2017", it is not validated. I need to validate while entering any incorrect format. Thanks.
    Last edited by inoka; 12-12-2017 at 01:38 AM.
    Reply With QuoteRegister To Reply
« 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. Check Date Format Input into Excel Column with VBA code
    By stanlelma in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-20-2024, 03:27 AM
  2. [SOLVED] Text box validation - date entry - format "dd mm yyyy"
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-25-2017, 09:01 AM
  3. [SOLVED] Userform Dynamically Generated Combobox format value as date ("mm/dd/yyyy")
    By CieloSalas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2017, 03:39 PM
  4. Having date data in "yyyy:mm:dd hh:mm:ss" format, =weekday formula does not work
    By imli123 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-21-2016, 08:56 AM
  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
  6. [SOLVED] Format a column as date format "yyyy-mm-dd"
    By Seraph122 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-11-2013, 01:30 AM
  7. Check if the cell format is date and change it to date Format(cell.Value, "yyyy/mm/dd")
    By ccs1981 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2012, 10:37 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