entering current time cell by cell

Molly · May 22nd, 2002, 03:23 PM

I want to assign 1 key instead of the shift+contro+: that I can tap to enter the current Hour:minute:second row by row in one column only.

Jack in the UK · May 22nd, 2002, 03:27 PM

Hi Molly

dare i ask why, two keys together or one single is all bar the same!

Al Chara · May 22nd, 2002, 05:13 PM

Hi Molly,

How about the following:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Value = Format(Time, "hh:mm:ss")
End Sub

It is a worksheet event that is triggered by changing the selection on the worksheet. So it will put the current time in the selected cell. You can click the down arrow key (only one key) and it will fill in the row.

I am not sure how familiar you are with VBA, but to enter this code...right click on your worksheet tab and select "View Code", then paste the code that I have provided into the big blank sheet. Then you should be ready.

Post with further questions.

May 22nd, 2002, 03:27 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Molly dare i ask why, two keys together or one single is all bar the same! __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 22nd, 2002, 05:13 PM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Hi Molly, How about the following: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Target.Value = Format(Time, "hh:mm:ss") End Sub It is a worksheet event that is triggered by changing the selection on the worksheet. So it will put the current time in the selected cell. You can click the down arrow key (only one key) and it will fill in the row. I am not sure how familiar you are with VBA, but to enter this code...right click on your worksheet tab and select "View Code", then paste the code that I have provided into the big blank sheet. Then you should be ready. Post with further questions. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 03:23 PM	#1
Molly New Member Join Date: May 2002 Posts: 1	I want to assign 1 key instead of the shift+contro+: that I can tap to enter the current Hour:minute:second row by row in one column only.