View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default macro for timestamp option button

With ActiveCell.Offset(0,1)
.Value = now
.NumberFormat = "mm/dd/yyyy hh:mm"
.EntireColumn.Autofit
End With

puts in a hard coded time rather than a volatile function.

--
Regards,
Tom Ogilvy

"gwallace" wrote in message
...
I have a worksheet with more than 1 button to timestamp
the exact time. I used the function "Now()". The problem
is when i click on one of the buttons all of the functions
are updated. Is there a way to correct this?