Adding A Date Command Button

Hey there. Here is what I would like to do. I am using Excel 2000. I would like to add a command button to my Excel form that, when pressed, will add 56 days to a cell on my spread sheet. I'm sure this is rather simple for you guys, but I really have no clue and it would be a huge help for me if you could send me the code. Thanks so much in advance.

Hello Hazy,

Here is a code example using A1 as the cell with the date of Oct, 15 2005. The result of adding 56 days will yield Dec 10, 2005.

Code Example:

With Worksheets("Sheet1")
.Range("A1").Value = .Range("A1").Value + 56
End With

Sincerely,
Leith Ross

Try:

Private Sub cmdAddDays_Click()
With Sheets("Sheet1").Range("A1")
If IsDate(.Value) Then
.Value = .Value + 56
End If
End With
End Sub

Hope this helps
Rowan

hazey wrote:
> Hey there. Here is what I would like to do. I am using Excel 2000. I
> would like to add a command button to my Excel form that, when pressed,
> will add 56 days to a cell on my spread sheet. I'm sure this is rather
> simple for you guys, but I really have no clue and it would be a huge
> help for me if you could send me the code. Thanks so much in advance.
>
>

Awesome, thanks a lot you guys! Works perfectly!

You're welcome.

hazey wrote:
> Awesome, thanks a lot you guys! Works perfectly!
>
>