eypress to activate VB-code

**ruttian** · 03-19-2013, 05:59 AM

I have this simple Spreadsheet for timekeeping (cross country skiing). It has a simple CommandButton1 to activate some VB-code:

Please Login or Register  to view this content.

But is there a way to activate this script with a simple keypress, ie F12?

**AB33** · 03-19-2013, 06:06 AM

Go to macro option and assign F12 to the code

**ruttian** · 03-19-2013, 06:35 AM

Originally Posted by AB33

Go to macro option and assign F12 to the code

I'm afraid I need a bit more guidance...

Do you mean from this control?:

Private Sub CommandButton1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)

End Sub

**AB33** · 03-19-2013, 06:52 AM

Alt+F8 will take to a new page where you need to choose the name of the code, then on the right hand side you see menus, one of them is option. When you click the option, you will see short-cut keys

**ruttian** · 03-19-2013, 07:02 AM

Originally Posted by AB33

Alt+F8 will take to a new page where you need to choose the name of the code, then on the right hand side you see menus, one of them is option. When you click the option, you will see short-cut keys

Thanks for Your reply, but there are no "Macros" (only a VB-script) in this Sheet. And If I choose this option, I need to press Ctrl+F12. I was looking for a single keypress option.

Thanks!

ruttian