+ Reply to Thread
Results 1 to 5 of 5

Current Date

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,382

    Current Date

    Hello:

    I need to display current date by pressing CTRL+D on any cell.


    Please help..

    Thanks.
    RM
    Last edited by rizmomin; 11-28-2012 at 11:12 PM.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,877

    Re: Current Date

    Use this code
    Please Login or Register  to view this content.
    to install,click on Alt + F11, Click on Insert, Module. Paste the code.
    close and save the vba.
    In your spreadsheet, select Alt+F8, Select Option. for the shortcut key enter a "D". Close and save.
    Last edited by alansidman; 11-28-2012 at 11:08 PM.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,844

    Re: Current Date

    Does it have to be Ctrl + D? Excel already has a built in key combination that will do that: Ctrl + ;

    - Moo

  4. #4
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,382

    Re: Current Date

    Hi:
    I like both solutions and thank u so much..

    Riz

  5. #5
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,844

    Re: Current Date

    You're welcome. And thanks for the rep.

+ 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