Thread: If cell is blank automatically enter today's date in the same cell
View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.misc
GS[_2_] GS[_2_] is offline
external usenet poster
  
Posts: 3,514
Default If cell is blank automatically enter today's date in the same cell
correction...

The code goes in the code window behind ThisWorkbook. It will run every time
the workbook is opened.

To access the VBE keyboard Alt+F11 and then expand the 'Microsoft
Excel

Objects' folder. Double-click on 'ThisWorkbook' and paste the code.

***Make sure you edit <sheetname to match the name of the sheet you want
this to affect***

**Remove this code if you put it anywhere other than in ThisWorkbook**

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


Reply With QuoteReply With Quote