Hi,

I am attempting to get my userForm to open without going into the VBA editor then 'run'. I have tried creating a shortcut but it is not bringing the userform up. Is it possible for somebody to please give me a walkthrough of how to create a shortcut for e.g. CTRL+SHIFT+O. (It keeps opening the panel that includes dictionary and thesaurus).

Thanks

You can create a subroutine that calls the form

Sub OpenForm
Form1.Show()
End Sub

and assign a shortcut key for this sub using OnKey method (http://vbadud.blogspot.com/2007/06/a...el-macros.html)

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)