|
Date not defaulting to current year
Hi there,
I would like a user to enter JUST the Day and Month....and the year default to 2008. Does anyone have any ideas? |
Date not defaulting to current year
Right click sheet tabview codecopy/paste thischange column to suitformat
column as desired Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 7 Then Exit Sub Application.EnableEvents = False Target = DateSerial("2008", Month(Target), Day(Target)) Application.EnableEvents = True End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Tim Elhatton" wrote in message ... Hi there, I would like a user to enter JUST the Day and Month....and the year default to 2008. Does anyone have any ideas? |
Date not defaulting to current year
Your subject line said "CURRENT" year and your msg said 2008.
On my xl2003 if if type 11/16 I automatically get the CURRENT year. -- Don Guillett Microsoft MVP Excel SalesAid Software "Tim Elhatton" wrote in message ... Hi there, I would like a user to enter JUST the Day and Month....and the year default to 2008. Does anyone have any ideas? |
Date not defaulting to current year
Thanks Don....
"Don Guillett" wrote: Your subject line said "CURRENT" year and your msg said 2008. On my xl2003 if if type 11/16 I automatically get the CURRENT year. -- Don Guillett Microsoft MVP Excel SalesAid Software "Tim Elhatton" wrote in message ... Hi there, I would like a user to enter JUST the Day and Month....and the year default to 2008. Does anyone have any ideas? |
| All times are GMT +1. The time now is 04:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com