| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro for timestamp option button
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help with timestamp macro | Excel Discussion (Misc queries) | |||
| macro for button option | Excel Discussion (Misc queries) | |||
| Timestamp Macro | Excel Worksheet Functions | |||
| keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
| Timestamp Button | Excel Discussion (Misc queries) | |||
Hybrid Mode
