View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bg18461[_6_] bg18461[_6_] is offline
external usenet poster
 
Posts: 1
Default textbox formula outside procedure

I am trying to have a textbox just show todays date. The only problem
am having is having this done outside a procedure. I dont want th
user to have to push a button or select a box, I simply want wheneve
the user opens the workbook, this particular cell to just show today
date. I tried to enter the formula: TextBox18 = Format(Date
"MM/DD/YYYY") in the general portion of of vba sheet (declarations) bu
i get outside procedure compile error, any hints..

--
Message posted from http://www.ExcelForum.com