| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting text format of time/date into Excel time/date for subtr | Excel Worksheet Functions | |||
| Storing data in Short Date format | New Users to Excel | |||
| Storing real time data into Sql Server | Excel Programming | |||
| storing real time data | Excel Discussion (Misc queries) | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Linear Mode
