Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to add date
Excellent ! That worked like a charm. Thansk again! I have another question, but this has no revelance to this topic so will start a new topic -- npereir ----------------------------------------------------------------------- npereira's Profile: http://www.excelforum.com/member.php...fo&userid=1079 View this thread: http://www.excelforum.com/showthread.php?threadid=26998 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to add date
One note of caution using that on a template. Every time you open an invoice
made from that template the date will update to today's date and overwrite the actual date the Invoice was created. I found this out the hard way myself. Mike F "npereira" wrote in message ... Excellent ! That worked like a charm. Thansk again! I have another question, but this has no revelance to this topic so I will start a new topic. -- npereira ------------------------------------------------------------------------ npereira's Profile: http://www.excelforum.com/member.php...o&userid=10799 View this thread: http://www.excelforum.com/showthread...hreadid=269988 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Code to add date
Good point.
If that's a concern to the OP: Option Explicit Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) With Me.Worksheets("sheet1").Range("e11") if .value = "" then .Value = Date .NumberFormat = "mmmm dd, yyyy" end if End With End Sub Checks what's in that cell first. Mike Fogleman wrote: One note of caution using that on a template. Every time you open an invoice made from that template the date will update to today's date and overwrite the actual date the Invoice was created. I found this out the hard way myself. Mike F "npereira" wrote in message ... Excellent ! That worked like a charm. Thansk again! I have another question, but this has no revelance to this topic so I will start a new topic. -- npereira ------------------------------------------------------------------------ npereira's Profile: http://www.excelforum.com/member.php...o&userid=10799 View this thread: http://www.excelforum.com/showthread...hreadid=269988 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
add 2nd Name and Date to Code | Excel Discussion (Misc queries) | |||
Convert a julian gregorian date code into a regular date | Excel Worksheet Functions | |||
code to convert date from TEXT format (03-02) to DATE format (200203) | Excel Programming | |||
code pasting a date changes date format in current month only | Excel Programming |