I have a Userform called, "OmniSelectorForm"
It has a Public Sub called OmniSelectorForm_Initialize
I try to call this UserForm through a macro triggered by shortcut key (Control+E). Macro is simple:
Sadly, the form does not show up. However, if I press F5 on the macro I am calling through the shortcut key, the UserForm comes up just fine. Any ideas?
Please Login or Register to view this content.
BeefNoodleSoup,
I just tested that, and the userform opened as expected when I used a keyboard shortcut.
It is important to note that keyboard shortcuts are case sensitive. So if your shortcut really is Ctrl+E, make sure you are using Ctrl+Shift+e to get the capital E.
You can view/change a macro's keyboard shortcut by pressing Alt+F8 and then selecting the macro name (in this case 'OmniSelector') and then click Options.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
My spreadsheet has a screenupdate so I know it's calling the macro but no UserForm shows up. I'll keep noodling on this, thanks for trying to help though
What did you name the UserForm and the Initialize event? I named my UserForm: OmniSelector in the Properties panel, but I left the initialize event as:
Reason being when I tried to change this to:Please Login or Register to view this content.
All it would do is pop up a form with no values insidePlease Login or Register to view this content.
he Initialize event cannot be a Public Sub.
Where's the short cut key, it's not in the code that you've posted
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
the Initialize event can be public but there's no real reason to make it so.
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks