trying to create a custom shortcut

icemonster

Registered User.
Local time
Today, 10:19
Joined
Jan 30, 2010
Messages
502
so i've been trying custom shortcut but i don't get this part of the tutorial. can someone help me?

To create an shortcut menu, you first have to create aCommandBar object. The CommandBar object represents the shortcut menu. Then, you use the Add method to create CommandBarControl objects. Each time that you create a CommandBarControl object, a command is added to the shortcut menu.

:D hehe. this is what happens when i learn access on my own :)
 
Hi,

I have little experience of this but can give you some pointers.

Firstly you need to create a reference to the Microsoft Office Library.
In the Visual Basic Editor go to Tools > References and check the "Microsoft Office x.0 Object Library"

If you are trying to add a new commandbar I'm guessing it will be something like this (untested):

Code:
Dim cb as CommandBar
Set cb = Application.CommandBars.Add(........)
 

Users who are viewing this thread

Back
Top Bottom