| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
POInv macro w/ if then statement
code works, thank you
jat "Roger Govier" wrote: Hi You could use something like Range("M7") = Format(date, "dd mmm yyyy") Date in VBA will return the current date. If you made your PO a Template, rather than a .xls file, you could save yourself the task of - cleans the purchase order back to original state - saves the new blank po -- Regards Roger Govier "jatman" wrote in message ... i have a macro that runs when i press the big button (macro is in module). macro does the following: - saves a copy of the purchase order based on the po number and date stamp - saves a copy on the hard drive - emails a copy to accounts payable - prints a copy for the actual invoice - cleans the purchase order back to original state - increases the po number by 1 - saves the new blank po the date cell contains "[Ctrl] ;" - i want them to use that so the date is entered in a preformatted condition and cannot be incorrect i used the following code at the start of the macro If .Range("M7") < "[Ctrl] ;" Then with End If at the end of the macro, but it does not work. is there any other way to enter the current date into the macro so that M7 self populates when the macro is run. - the code =today() cannot be used because the copy stored on the hard drive keeps updating itself when the file is opened. regards jat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If then for POInv macro | Excel Programming | |||
| If statement in macro | Excel Discussion (Misc queries) | |||
| how can i use an if statement to run a macro? | Excel Programming | |||
| HELP w/ Macro and IF Statement | Excel Programming | |||
| Macro or IF statement??? HELP! | Excel Programming | |||
Hybrid Mode
