| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Current date and time when pressing a command button
Hello, I would like to get the current date and time when pressing a comman button in cell A5 what would the vba code be? Any help will be appreicated. Thank you in advance. Regards, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add Current date and time when pressing a command button
Hello;
Cells(5, 1) = Format(Now, "DD/MM/YYYY : HH/MM/SS") The format can be adjusted according to your regional settings. -- Regards; Mark Rosenkrantz -- Spreadsheet Solutions Uithoorn Netherlands (the country were they live some 18 feet beyond sea level) -- E: W: www.spreadsheetsolutions.nl -- "CAM" wrote in message ... Hello, I would like to get the current date and time when pressing a comman button in cell A5 what would the vba code be? Any help will be appreicated. Thank you in advance. Regards, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add Current date and time when pressing a command button
Mark, Thanks for the tip. I appreciate your help. Regards "Spreadsheet Solutions" wrote in message ... Hello; Cells(5, 1) = Format(Now, "DD/MM/YYYY : HH/MM/SS") The format can be adjusted according to your regional settings. -- Regards; Mark Rosenkrantz -- Spreadsheet Solutions Uithoorn Netherlands (the country were they live some 18 feet beyond sea level) -- E: W: www.spreadsheetsolutions.nl -- "CAM" wrote in message ... Hello, I would like to get the current date and time when pressing a comman button in cell A5 what would the vba code be? Any help will be appreicated. Thank you in advance. Regards, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Command button auto select after pressing Enter | Excel Programming | |||
| Button to set current time | Excel Programming | |||
| Command Button Date/Time Stamp | Excel Programming | |||
| How can i use a command button to validate date and time | Excel Discussion (Misc queries) | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
Hybrid Mode
