| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date defaults to current year | Excel Discussion (Misc queries) | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| calculate prior calendar year end from a moving current date | Excel Worksheet Functions | |||
| How to compare current year to prior year in bar chart? | Charts and Charting in Excel | |||
| Date Defaulting | Excel Worksheet Functions | |||
Linear Mode
