+ Reply to Thread
Results 1 to 2 of 2

vba: isDate function

  1. #1
    phil
    Guest

    vba: isDate function

    I need to check if a cell contains a date value of particular format
    (dd/mm/yyyy). It looks like isDate checks only for a date value and not the
    format of the date. Is there any other function that i can use to do this.

    thanks.

  2. #2
    JMB
    Guest

    RE: vba: isDate function

    MsgBox ActiveCell.NumberFormat = "dd/mm/yyyy"

    "phil" wrote:

    > I need to check if a cell contains a date value of particular format
    > (dd/mm/yyyy). It looks like isDate checks only for a date value and not the
    > format of the date. Is there any other function that i can use to do this.
    >
    > thanks.


+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1