+ Reply to Thread
Results 1 to 10 of 10

Automatic time and date change

Hybrid View

  1. 02-14-2014, 11:57 AM #1
    strud
    strud is offline
    Forum Contributor
    Join Date
    04-19-2013
    Location
    Yorkshire, England
    MS-Off Ver
    Excel 2010
    Posts
    297

    Re: Automatic time and date change

    See attached- a solution using VBA- I think this is what you wanted- when you change the value in cell A1 and hit enter the date and time in b1 l will change

    If you require an explanation just ask

    Regards
    Strud
    Attached Files Attached Files
    Last edited by strud; 02-14-2014 at 12:00 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. automatic change of date according to month
    By marija144 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2013, 05:09 PM
  2. [SOLVED] Automatic Date Update/Change
    By *C* in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-27-2012, 02:59 PM
  3. Change date automatic in an excel column
    By Dahlgren in forum Excel General
    Replies: 2
    Last Post: 04-22-2012, 11:05 PM
  4. Date and time calculations and automatic date changes
    By Arlette in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-09-2006, 05:25 AM
  5. Automatic date and time updation
    By Qlychap in forum Excel General
    Replies: 12
    Last Post: 07-21-2006, 10:00 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