Shortcuts in VBA?

[ProgramError]

Is there a way of programming a keyboard shortcut for use when programming in VBA?

for example instead of typing 'debug.print' every time I'd like to be able to press ctrl+B instead and it enter the debug.print statement in the code.

P.S.
I know that if you type 'debug.?' it will change it to 'debug.print'

Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.

 

[SkipVought]

Hi,

Start a word and hit ctr+space to complete.

Skip,

_[red][/red]

 

[ProgramError]

Thanks SkipVought, not quite what I had in mind but will be useful though.

Anyone else have the solution?

Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.

 

[CautionMP]

ProgramError,
Your probably looking at creating Add-in for Access. Check out the following help files:[ul]
[li][tt]Events Object[/tt]: Supplies properties that enable add-ins to connect to all events in Visual Basic for Applications.[/li]
[li][tt]CommandBarEvents Property[/tt][/li]
[li][tt]Click Event (VBA Add-In Object Model)[/tt][/li][/ul]

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[dhookom]

If you don't use MZ-Tools, you should. There are lots of neat features including keeping snippets available for quick insertion into your code.

http://www.mztools.com/index.htm

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]