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

Hello,

how to get the current time by clicking command button for any active cell

Which function will you use to enter current time in a woksheet cell ?
How to enter @ in laptop - Guide
Popcorn time download - Download - Movies, series and TV
Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
How to change time in whatsapp - Guide
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum

3 responses

Answer 1 / 3

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

Private Sub CommandButton1_Click()
ActiveCell = Now()
ActiveCell.NumberFormat = "hh:mm:ss"
End Sub

dhoom
Aug 20, 2010 at 03:24 AM

whr z cmmnd button in ctrl toolbar??i hv to wrk this thing in excel sheet & thr z no control toolbar thr.....
I wnt to display current time whn a cell of xcel sheet is clicked..

Answer 2 / 3

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 20, 2010 at 05:44 AM

of course you can bring the button from the form toolbar. view-toolbars-form

alternatively do this
right click sheet tab and click view code.
there you copy this event code
AFTER SELECTING A CELL YOU HAVE TO RIGHT CLICK THE CELL

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) 
Cancel = True 
Target = Now() 
Target.NumberFormat = "hh:mm:ss" 
End Sub

Terriable at this
Aug 26, 2010 at 02:45 AM

how to isolate it to certain cells.

Similar discussions

Enter current time in a cell by clicking it

If a cell contains any text then add a value

Excel multiple functions in one cell

If cell = date return yes or no.

my computer cannot read SD card

Excel - IF function with multiple words

Similar discussions

Subscribe To Our Newsletter!