Date Change Macro

E

Eschroeter

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.
 
O

Olly

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
 
D

Dave Peterson

You have replies at your other post.
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.
Click to expand...
 
Top