Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple macro | Excel Discussion (Misc queries) | |||
Writing a simple macro or formula | Excel Programming | |||
Simple macro please | New Users to Excel |