Excel Macro - Keystroke

[eric]

Hi,

How do I integrate a keystroke on my recorded macro.. For instance...

I would like to create a macro which when you run, it automatically enters
the current time on a fixed cell. I know that ctrl+shift+; will enter the
current time in the cell but I cant seem to record that keystroke on a macro.

Thanks,
Eric

 

[Luke M]

Rather than using keystrokes which is genearlly frowned upon (although it
could be done with SendKeys) simply have your macro state something like:

Range("A2") = TimeValue(Now)

 

[eric]

works like a charm.. Thanks Luke!

Rather than using keystrokes which is genearlly frowned upon (although it
could be done with SendKeys) simply have your macro state something like:

Range("A2") = TimeValue(Now)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

 

[Luke M]

or simply,
Range("A2") = Time

"Now" is used if you need the date.