Application.Keys
This property returns a collection of current keyboard accelerators for the associated document type.
| Syntax | Parameters | Return Value |
|---|---|---|
ReadOnly Property Application.Keys( _
DocTypeForKeys As DocumentType) As Keys
|
DocTypeForKeys [in]
Type: DocumentType |
Keys |
SVB Example
Adding custom hot keys:
Option Base 1
Option Explicit
Sub Main
MsgBox "Adding CTRL+Q to launch Basic Statistics from a spreadsheet"
'Make CTRL+Q a hot key for open Basic Statistics when a spreadsheet
'is active. In the function "Add", 11 represents CTRL and 81 represents
'Q (which is its ASCII table equivalent).
Application.Keys(scSpreadsheet).Add(11,81,scCmdStatsBasicStatsTables)
End Sub
Copyright © 2020. Cloud Software Group, Inc. All Rights Reserved.
