View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rexmann rexmann is offline
external usenet poster
 
Posts: 79
Default Macro for data and time

Hi

I have recently started to use Excel 2007 and have tried to create a macro
that records the date and time. I have recorded the key strokes ctrl ; and
space and ctrl shift ;

Unfortunately it just enters the date at the time I recorded the macro. I
would like to record just the key strokes so it puts in the date and time at
the time the macro is run. Is this possible? I am not a great expert at
visual basic but can normally fudge a solution! Any suggestion to do this?

Any help greatly appreciated

rexmann