Changing function key definition to insert time
 

We use Excel at work and now due to some changes in procedures, we are
required to insert a start and stop time for our testing procedures. While I
know about the control + shift + : to insert time, I was hoping for someway
to change a function key to do this. We have numerous people doing this
testing and it would make life alot easier to just hit one key instead of the
three

Changing function key definition to insert time
 

One way to do it would be to have an add-in installed with the line:

Application.OnKey "{F8}", "TimeAdder"

in its WorkBook_Open event, and in its Module, the Sub:

Sub TimeAdder()
ActiveCell.Value = Time
End Sub

This would replace the F8 function with this Sub's function.


MedTech wrote:
We use Excel at work and now due to some changes in procedures, we are
required to insert a start and stop time for our testing procedures. While I
know about the control + shift + : to insert time, I was hoping for someway
to change a function key to do this. We have numerous people doing this
testing and it would make life alot easier to just hit one key instead of the
three

Changing function key definition to insert time
 

Now realize that I work with excel and know a little, but doing macros and
visual basic is totally new to me. When you say to have a add in installed...
just how and where do I do this.

"JakeyC" wrote:

One way to do it would be to have an add-in installed with the line:

Application.OnKey "{F8}", "TimeAdder"

in its WorkBook_Open event, and in its Module, the Sub:

Sub TimeAdder()
ActiveCell.Value = Time
End Sub

This would replace the F8 function with this Sub's function.


MedTech wrote:
We use Excel at work and now due to some changes in procedures, we are
required to insert a start and stop time for our testing procedures. While I
know about the control + shift + : to insert time, I was hoping for someway
to change a function key to do this. We have numerous people doing this
testing and it would make life alot easier to just hit one key instead of the
three

Changing function key definition to insert time
 

An Add-In is simply a standard workbook, but saved as an Add-in (.xla)
instead of the normal .xls so it is 'invisible' when in use. You can
set this option (along with Html, CSV, etc.) during SaveAs.

To install an Add-In, go to Tools - Add-ins and use Browse... to find
the .xla file you saved. Make sure there's a check in the box next to
it in the list of Add-Ins and you're ready to go.

Check Help (F1) for more detailed info.


MedTech wrote:
Now realize that I work with excel and know a little, but doing macros and
visual basic is totally new to me. When you say to have a add in installed...
just how and where do I do this.

"JakeyC" wrote:

One way to do it would be to have an add-in installed with the line:

Application.OnKey "{F8}", "TimeAdder"

in its WorkBook_Open event, and in its Module, the Sub:

Sub TimeAdder()
ActiveCell.Value = Time
End Sub

This would replace the F8 function with this Sub's function.


MedTech wrote:
We use Excel at work and now due to some changes in procedures, we are
required to insert a start and stop time for our testing procedures. While I
know about the control + shift + : to insert time, I was hoping for someway
to change a function key to do this. We have numerous people doing this
testing and it would make life alot easier to just hit one key instead of the
three

Changing function key definition to insert time
 

Thanks, I'll give this a try


"JakeyC" wrote:

An Add-In is simply a standard workbook, but saved as an Add-in (.xla)
instead of the normal .xls so it is 'invisible' when in use. You can
set this option (along with Html, CSV, etc.) during SaveAs.

To install an Add-In, go to Tools - Add-ins and use Browse... to find
the .xla file you saved. Make sure there's a check in the box next to
it in the list of Add-Ins and you're ready to go.

Check Help (F1) for more detailed info.


MedTech wrote:
Now realize that I work with excel and know a little, but doing macros and
visual basic is totally new to me. When you say to have a add in installed...
just how and where do I do this.

"JakeyC" wrote:

One way to do it would be to have an add-in installed with the line:

Application.OnKey "{F8}", "TimeAdder"

in its WorkBook_Open event, and in its Module, the Sub:

Sub TimeAdder()
ActiveCell.Value = Time
End Sub

This would replace the F8 function with this Sub's function.


MedTech wrote:
We use Excel at work and now due to some changes in procedures, we are
required to insert a start and stop time for our testing procedures. While I
know about the control + shift + : to insert time, I was hoping for someway
to change a function key to do this. We have numerous people doing this
testing and it would make life alot easier to just hit one key instead of the
three

Changing function key definition to insert time
 

well, 3 of us has tried to enter this and none of us can get it to work. Can
you go thru this step by step to see where we screwed up in the entering..

"MedTech" wrote:

Thanks, I'll give this a try


"JakeyC" wrote:

An Add-In is simply a standard workbook, but saved as an Add-in (.xla)
instead of the normal .xls so it is 'invisible' when in use. You can
set this option (along with Html, CSV, etc.) during SaveAs.

To install an Add-In, go to Tools - Add-ins and use Browse... to find
the .xla file you saved. Make sure there's a check in the box next to
it in the list of Add-Ins and you're ready to go.

Check Help (F1) for more detailed info.


MedTech wrote:
Now realize that I work with excel and know a little, but doing macros and
visual basic is totally new to me. When you say to have a add in installed...
just how and where do I do this.

"JakeyC" wrote:

One way to do it would be to have an add-in installed with the line:

Application.OnKey "{F8}", "TimeAdder"

in its WorkBook_Open event, and in its Module, the Sub:

Sub TimeAdder()
ActiveCell.Value = Time
End Sub

This would replace the F8 function with this Sub's function.


MedTech wrote:
We use Excel at work and now due to some changes in procedures, we are
required to insert a start and stop time for our testing procedures. While I
know about the control + shift + : to insert time, I was hoping for someway
to change a function key to do this. We have numerous people doing this
testing and it would make life alot easier to just hit one key instead of the
three

Changing function key definition to insert time
 

If you email me, I'll reply later today with the add-in attached for
you to install.


MedTech wrote:
well, 3 of us has tried to enter this and none of us can get it to work. Can
you go thru this step by step to see where we screwed up in the entering..

"MedTech" wrote:

Thanks, I'll give this a try


"JakeyC" wrote:

An Add-In is simply a standard workbook, but saved as an Add-in (.xla)
instead of the normal .xls so it is 'invisible' when in use. You can
set this option (along with Html, CSV, etc.) during SaveAs.

To install an Add-In, go to Tools - Add-ins and use Browse... to find
the .xla file you saved. Make sure there's a check in the box next to
it in the list of Add-Ins and you're ready to go.

Check Help (F1) for more detailed info.


MedTech wrote:
Now realize that I work with excel and know a little, but doing macros and
visual basic is totally new to me. When you say to have a add in installed...
just how and where do I do this.

"JakeyC" wrote:

One way to do it would be to have an add-in installed with the line:

Application.OnKey "{F8}", "TimeAdder"

in its WorkBook_Open event, and in its Module, the Sub:

Sub TimeAdder()
ActiveCell.Value = Time
End Sub

This would replace the F8 function with this Sub's function.


MedTech wrote:
We use Excel at work and now due to some changes in procedures, we are
required to insert a start and stop time for our testing procedures. While I
know about the control + shift + : to insert time, I was hoping for someway
to change a function key to do this. We have numerous people doing this
testing and it would make life alot easier to just hit one key instead of the
three