Results 1 to 6 of 6

Force user to fill date values in cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-19-2010
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    151

    Force user to fill date values in cells

    Hello,

    I need to define validation rule to a range of cells.
    All cells should accept only DATE inputs
    in format "mm/dd/yy".

    I used VBA to set the format of a RANGE:

    rng.Select
    Selection.NumberFormat = "mm/dd/yy"

    but excel accept general string inputs etc.

    Can you help me ?

    Thank you
    Last edited by Snoopy2003; 09-03-2010 at 03:56 PM.

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