Current Date

[rizmomin]

Hello:

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


Please help..

Thanks.
RM

[alansidman]

Use this code

Sub ShowDate()
    ActiveCell = Date
End Sub

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.

[Moo the Dog]

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

- Moo

[rizmomin]

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

Riz

[Moo the Dog]

You're welcome. And thanks for the rep.