Function F3 key assignment

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

How would I assign a key stroke (in this case a monosorts
character of a checkmark)to the F3 key? It was there
before they gave me a new computer, now it won't work.
Thanks.
 
How would I assign a key stroke (in this case a monosorts
character of a checkmark)to the F3 key? It was there
before they gave me a new computer, now it won't work.
Click to expand...

It requires programming. One way is

Sub Auto_Open()
Application.OnKey key:="{F3}", Procedure:="CheckMark"
End Sub

Sub Auto_Close()
Application.OnKey key:="{F3}"
End Sub

Sub CheckMark()
Application.ScreenUpdating = False
ActiveCell.Formula = "3"
ActiveCell.Font.Name = "Monotype Sorts"
End Sub

all inside a general VBA module.
 
Thanks, I'll give it a try.
-----Original Message-----
...

It requires programming. One way is

Sub Auto_Open()
Application.OnKey key:="{F3}", Procedure:="CheckMark"
End Sub

Sub Auto_Close()
Application.OnKey key:="{F3}"
End Sub

Sub CheckMark()
Application.ScreenUpdating = False
ActiveCell.Formula = "3"
ActiveCell.Font.Name = "Monotype Sorts"
End Sub

all inside a general VBA module.

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.
.
Click to expand...
 
Back
Top