Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help : Macro for capturing current system time
Hi,
I am currently working on an excel worksheet. It requires macro button for capturing the system time at that particular moment i certain columns. I would like to know how to solve this problem i coding the macro for such a functionality. Please help me. Regards IM -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help : Macro for capturing current system time
Range("A1").Value = Time
Or am I missing something? -- Vasant "imr " wrote in message ... Hi, I am currently working on an excel worksheet. It requires a macro button for capturing the system time at that particular moment in certain columns. I would like to know how to solve this problem in coding the macro for such a functionality. Please help me. Regards IMR --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help : Macro for capturing current system time
Hi Vasant,
Thanks for the solution, but it works for the particular cel alone. It appears that i have to code for each cell. Is there anyway to generalise the code, so that wherever i click on th worksheet, the system time at that particular moment is updated and th cell is also protected after this. Please do let me know. Regards im -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help : Macro for capturing current system time
I'm a bit confused ... do you want this to happen for every cell on the
worksheet? In any event there is no good way to capture a click on a worksheet. You can capture a double-click or a right-click, for example: Private Sub Worksheet_BeforeDoubleClick(ByVal _ Target As Range, Cancel As Boolean) If Not Intersect(Target, Range("A:A")) Is Nothing Then Cancel = True Target = Time End If End Sub Placing this code in the worksheet code module will cause any cell in column A to be updated with the system time when double-clicked. -- Vasant "imr " wrote in message ... Hi Vasant, Thanks for the solution, but it works for the particular cell alone. It appears that i have to code for each cell. Is there anyway to generalise the code, so that wherever i click on the worksheet, the system time at that particular moment is updated and the cell is also protected after this. Please do let me know. Regards imr --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying the current system time - 2nd Try | Excel Worksheet Functions | |||
macro for current time | Excel Discussion (Misc queries) | |||
How to write a macro to get the system time in excel 97 | Excel Discussion (Misc queries) | |||
On Error, Capturing current module and actual line of code | Excel Programming | |||
excel - macro - automatic initiation of a macro at a pre-specified "system time" | Excel Programming |