View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Auto date or comment entry

How about

CTRL-;

??

In article ,
Simon Lloyd wrote:

Any ideas on how i get a cell that i enter a letter or single digit
number to display todays date in the cell or in a comment box for that
cell using macros, also i do not want the date already entered in a
cell to refresh when the workbook is opened another day, I have no
workings for this yet as i am very new to visual basic!