M
michaaal
How can I get my newly created VB Sub to show up when I
click Tools / Macro / Macros?
(Outlook 2003)
click Tools / Macro / Macros?
(Outlook 2003)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sue Mosher [MVP-Outlook]
Why would you expect a VB sub to show up in your VBA project? Or did you
mean "VBA sub"? Did you declare it Public?
mean "VBA sub"? Did you declare it Public?
M
michaaal
No I didn't declare it as Public. It sounds like that may be my solution.
How do I declare a sub as public? I tried just putting "Public" in front of
it, but this didn't seem to solve the problem.
How do I declare a sub as public? I tried just putting "Public" in front of
it, but this didn't seem to solve the problem.
S
Sue Mosher [MVP-Outlook]
I'm still wondering if you meant "VBA Sub" when you wrote "VB Sub"?
Yes, you declare a subroutine public by putting Public in front of Sub.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
Yes, you declare a subroutine public by putting Public in front of Sub.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
M
michaaal
Sue Mosher said:I'm still wondering if you meant "VBA Sub" when you wrote "VB Sub"?
Yes, you declare a subroutine public by putting Public in front of Sub.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
I apologize for not clarifying the difference. Would you mind helping me
out with this? I can tell you exactly the steps I took to create the sub if
that helps?
S
Sue Mosher [MVP-Outlook]
So this is VBA? Does the code run OK if you run it from the VBA environment?
Does the subroutine have any arguments?
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
Does the subroutine have any arguments?
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
M
michaaal
Sue Mosher said:So this is VBA? Does the code run OK if you run it from the VBA environment?
Does the subroutine have any arguments?
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
The subroutine has no arguments.
S
Sue Mosher [MVP-Outlook]
So this is VBA? What module did you create the subroutine in? Does the code
run OK in the VBA environment? Do other subs appear in the Tools | Macro |
Macros list?
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
run OK in the VBA environment? Do other subs appear in the Tools | Macro |
Macros list?
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers