Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Change Macro
In Microsoft Money and Quicken, you have the ability to change the date up or
down by using the "+" and "-" keys. Does anyone know of a way to do that in Excel? For instance, suppose you had a column of dates. I'm looking for a way to arrow down this column and adjust each date accordingly by hitting the plus or minus keys instead of manually retyping each date. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Change Macro
This works, but you have to press Enter after + or -
Private Sub Worksheet_Change(ByVal Target As Range) Select Case Target.Value Case "+": Application.Undo Target.Value = Target.Value + 1 Case "-": Application.Undo Target.Value = Target.Value - 1 End Select End Sub -- Olly "Eschroeter" wrote in message ... In Microsoft Money and Quicken, you have the ability to change the date up or down by using the "+" and "-" keys. Does anyone know of a way to do that in Excel? For instance, suppose you had a column of dates. I'm looking for a way to arrow down this column and adjust each date accordingly by hitting the plus or minus keys instead of manually retyping each date. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Change Macro
You have replies at your other post.
Eschroeter wrote: In Microsoft Money and Quicken, you have the ability to change the date up or down by using the "+" and "-" keys. Does anyone know of a way to do that in Excel? For instance, suppose you had a column of dates. I'm looking for a way to arrow down this column and adjust each date accordingly by hitting the plus or minus keys instead of manually retyping each date. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
macro to change date ranges | Excel Discussion (Misc queries) |