+ Reply to Thread
Results 1 to 1 of 1

Multiple Time Stamps Based On Data Validation Selection

  1. #1
    Registered User
    Join Date
    02-08-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Multiple Time Stamps Based On Data Validation Selection

    Hello all,

    I have created a column that has 9 different selections using DataValidation and have 9 different columns for each selection. Would it be possible to insert a time stamp in the appropriate column for when the corresponding selection is made in the column with the data validation?

    Please advise,

    T

  2. #2
    Valued Forum Contributor smuzoen's Avatar
    Join Date
    10-28-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    610

    Re: Multiple Time Stamps Based On Data Validation Selection

    You would have to provide a sample workbook to show exactly what you are after however with a worksheet_change event when the user selects a value from the drop down box you can place a time stamp in the appropriate column - you could have to adapt the following to your needs. If you need a more specific answer please upload a sample workbook with no sensitive data showing how your workbook is set up and showing how you want it to appear (the result)
    Please Login or Register  to view this content.
    Hope this helps.
    Anthony
    Pack my box with five dozen liquor jugs
    PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated?

+ 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