Excel Macro - Keystroke
 

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

Excel Macro - Keystroke
 

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!*


"eric" wrote:

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

Excel Macro - Keystroke
 

works like a charm.. Thanks Luke!

"Luke M" wrote:

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!*


"eric" wrote:

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

Excel Macro - Keystroke
 

or simply,
Range("A2") = Time

"Now" is used if you need the date.
--
Best Regards,

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


"Luke M" wrote:

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!*


"eric" wrote:

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