View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SoupNazi SoupNazi is offline
external usenet poster
 
Posts: 9
Default how to enter data "OnTime", OR when workbook opened

I need to add "8" to the total amount in a cell automatically on the 1st of
every month. I understand I can use the OnTime function for this if excel is
running at the time that I set. If Excel is not running at that time, can I
set it up to enter that digit the first time I open Excel after the 1st of
the month? I am a beginner at VB, so I really need to be walked through this.
Thanks a lot.