Storing date and time
 

Hello,

I have several macro's which are run periodically. I'd like to store the
date and time in the cells next to each of the macro buttons after the macro
was executed. Does anyone know how to do this with VBA-code?

Thanx.

Noepie

Storing date and time
 

If the button is in E4
Range("F4").value= Now

Paul

"Noepie" wrote in message
...
Hello,

I have several macro's which are run periodically. I'd like to store the
date and time in the cells next to each of the macro buttons after the
macro
was executed. Does anyone know how to do this with VBA-code?

Thanx.

Noepie

Storing date and time
 

Maybe this

Sub Button2_Click()
Range(ActiveSheet.Buttons(Application.Caller).Bott omRightCell.Offset(-2,
1).Address).Value = Now
End Sub

Mike

"Noepie" wrote:

Hello,

I have several macro's which are run periodically. I'd like to store the
date and time in the cells next to each of the macro buttons after the macro
was executed. Does anyone know how to do this with VBA-code?

Thanx.

Noepie