Run VBA Userform in Outlook

  • Thread starter Thread starter John Ford
  • Start date Start date
J

John Ford

NOT a question about "Outlook Forms". This is a Userform in
Outlook's VBA Editor.

I'm missing something very basic. I can't figure out how to run a
VBA form that I've created in my Outlook VbaProject.OTM, unless
I'm in the VBA Editor (where I just have to press F5).

How do I run a Userform without being in the VBA editor?
 
You can create a sub in a module such as:

Sub LoadMyForm()
UserForm1.Show
End Sub


Or use that code in whatever event you'd like to load that form.

Ray at work
 
I thought it might be something like that. Then I just make a
toolbar button that runs the dumb little "LoadMyForm", right?

I _do_ wish they'd make it easier to deploy Outloook VBA stuff to
coworkers!

-jcf

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in
message | You can create a sub in a module such as:
|
| Sub LoadMyForm()
| UserForm1.Show
| End Sub
|
|
| Or use that code in whatever event you'd like to load that form.
|
| Ray at work
|
| | > NOT a question about "Outlook Forms". This is a Userform in
| > Outlook's VBA Editor.
| >
| > I'm missing something very basic. I can't figure out how to
run a
| > VBA form that I've created in my Outlook VbaProject.OTM,
unless
| > I'm in the VBA Editor (where I just have to press F5).
| >
| > How do I run a Userform without being in the VBA editor?
| >
| > --
| > jcf
| >
|
|
 
Do you know how to create a new button? Take a look in the Macros
categories on the Commands tab of the Tools--customize dialog. Your macro
will appear there if it exists as a non-private sub in a module and does not
have any arguments.

Ray at work
 
Back
Top