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.

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.

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