VBA project using SendKeys

Hi All,

Can you please help me on using sendkeys for 'DATE' and 'TIME' function?

I manually use for Date —› Ctrl + ;
I manually use for Time —› Ctrl + Shift + ;

If I use formulas - "=Today()" and "=Now()" in my VBA codes then I have to use copy & paste codes, so that the date & time get fixed, and don't change/ update if I use codes for the next time.

Thanks in Advance!

Hi

If I use formulas - "=Today()" and "=Now()" in my VBA codes then I have to use copy & paste codes, so that the date & time get fixed, and don't change/ update if I use codes for the next time.

If you want to put the date/time into a cell, why don't you just use the VBA functions?

eg.

Please Login or Register  to view this content.

Trust me, Sendkeys can be quite unreliable and should be avoided when possible.

Please Login or Register  to view this content.

Thanks Colin Legg for ur amazing help on this.
...and okay! I will try to avoid using the send-keys in my codes.

Hi,

Yes, you can use the Format function to do that, for example:

Please Login or Register  to view this content.

Thanks a world for ur amazing help!

Please Login or Register  to view this content.

P.S. - I'd like to learn these smart tricks.