shortcut help

[ph03]

Hi all- How do I incorporate CTRL combination shortcuts into my VBA syntax. For instance, I'd like the current date to appear in my worksheet at A1. Without a VBA macro I'd select A1 and type Ctrl+;. How to I tell my program to do this automatically? -Thanks!

 

[RoryA]

Range("A1").value = Date

 

[ph03]

Thanks!