Current time by clicking comm button in excel
Closed
geoganesh_80
Posts
1
Registration date
Monday July 12, 2010
Status
Member
Last seen
July 12, 2010
-
Jul 12, 2010 at 05:05 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 26, 2010 at 03:48 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 26, 2010 at 03:48 AM
Related:
- Which function will you use to enter current time in a worksheet cell?
- Popcorn time - Download - Movies, series and TV
- Activeworkbook.worksheets current worksheet ✓ - Excel Forum
- How to enter @ in laptop - Guide
- Insert the current date and time in cell a1 ✓ - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
3 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 12, 2010 at 05:58 AM
Jul 12, 2010 at 05:58 AM
bring a "comman button" from the control toolbar and place it somewhere in the sheet.
right click the sheet tab and click view code. There you copy this code
right click the sheet tab and click view code. There you copy this code
Private Sub CommandButton1_Click() ActiveCell = Now() ActiveCell.NumberFormat = "hh:mm:ss" End Sub
Aug 20, 2010 at 03:24 AM
I wnt to display current time whn a cell of xcel sheet is clicked..