Accelerator Keys

[VBAva]

hello

i know this is probably a simple question but i cant seen to find the answer :-(

i have user forms and a custom menu bar and i would like to have accelerator keys or shortcut keys for the buttons, but i cant figure out how to do it.
i cant find it in the excel help either.

thanks for your time
Ava

 

[VBAva]

oops, i always post questons and figure out the answer soon after!

it is very easy to get the accelerator keys in for a menu item
eg
(this is just and excerpt so it wont work on its own)

Set ctlPopUpFile = EditBar.Controls.Add(msoControlPopup)
With ctlPopUpFile
.Caption = "&Open File"
.BeginGroup = False
.Enabled = True
End With


This creates a button on a custom menu bar called Open File, with O as the accelerator key