LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Simple if formula in a macro

Hi folks,

I have a very simple request, but my VBA days are way gone and I dont
really know how it works with excell.

All I need is a IF statement that checks cell A26 to see if it is empty
or if it includes a date entry (IE nov/11).

If the cell is empty or if the date is equal to at least today then do
nothing.
If the date in the cell is older than todays date, then call sub
routine and put today date on cell a26.

Thats it.

I plan on assigning this macro to a button, but it would be better if
this routine was run automatically everytime the worksheet was opened,
how is it done?

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF formula-simple question; simple operator Rich D Excel Discussion (Misc queries) 4 December 6th 07 03:36 PM
Simple problem, simple formula, no FUNCTION ! Ron@Buy Excel Worksheet Functions 6 September 28th 07 04:51 PM
Simple macro MikeD1224 Excel Discussion (Misc queries) 1 June 9th 07 12:06 AM
Writing a simple macro or formula Robin Excel Programming 2 January 28th 06 11:10 PM
Simple macro please sasha New Users to Excel 1 July 19th 05 12:51 PM


All times are GMT +1. The time now is 06:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"