+ Reply to Thread
Results 1 to 3 of 3

Set Data Validation Default Values

  1. #1
    Registered User
    Join Date
    08-28-2013
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010, 2013
    Posts
    69

    Question Set Data Validation Default Values

    Good afternoon! I've looked through the forum, and have seen several requests for data validation defaults, but not related to cells that need to repopulate to defaults based on an action. I'm attaching my worksheet to get an understanding of what I'm trying to accomplish.

    Default Data Validation Help.xlsx

    Basically, any time a new employee name is selected, I want default review begin and end dates populated to the data validation cells so that the dates don't have to be manually selected every time a new employee is reviewed.

    Any assistance is appreciated!

    Thanks!

    Jan

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,602

    Re: Set Data Validation Default Values

    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    08-28-2013
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2010, 2013
    Posts
    69

    Re: Set Data Validation Default Values

    Thank you so much, protonLeah! I appreciate the help!

+ 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. [SOLVED] Data Validation default setting
    By AndyMan81 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2014, 11:12 AM
  2. set default value using data validation
    By hai_krk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2012, 12:00 AM
  3. Default text in Data Validation
    By sats43 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-30-2010, 08:55 AM
  4. Replies: 2
    Last Post: 11-17-2008, 09:14 PM
  5. Default value in data validation
    By broogle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2005, 10:06 AM

Tags for this Thread

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