+ Reply to Thread
Results 1 to 5 of 5

Launching a form in Outlook

  1. #1
    Registered User
    Join Date
    02-01-2014
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    10

    Launching a form in Outlook

    I created a userform in VBA. I have all the code working and added a link to my ribbon. The is called OutMess.out in the Macro area of ribbon Customization. In VBA my form is called "Out". The Module is just called Module1. Double clicking on Module1 in the VBA editor brings me to VbaProject.OTM - Module1(Code) where the following code is trying to load the userform "Out".

    Please Login or Register  to view this content.
    When I try to run my projec tI get Run Time Error 424
    Object required. and it highlight the code UserforOut.Show above. What am I doing wrong? I had it working but couldn't get the stupid thing certified to run and ended up deleting it and can't remember how it was calling the form.

    Can anyone straighten me out again?


    Thanks,

    Mum-O-Killowe

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Launching a form in Outlook

    Your code is attempting to load a form called UserFormOut. If you want to load a form called Out then you want

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-01-2014
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Launching a form in Outlook

    I had tried that but when I use that I get an Compile Error: expected function or variable and highlights the Out in Out.Show.

    Thanks,

    Mum-O-Killowe

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Launching a form in Outlook

    In your VBA development window, right click on the form Out and then select Export. Do the same thing with Module1. Then attach the two .bas files that are exported. I created a situation like the one you described and everything worked perfectly. So I need to see your modules.

  5. #5
    Registered User
    Join Date
    02-01-2014
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Launching a form in Outlook

    I recreated the sub to be

    Please Login or Register  to view this content.
    and it is working. Outlook still balks at the digital signature when I try to put it on another machine so the fight continues...grrrr. Seems to have come to terms with it on my machine somehow. (I can certainly still post the exported files if you are curious, just let me know.)

    Thanks for the help,

    Mum-O-Killowe

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Outlook New Contact Form
    By bellah in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 05-06-2013, 02:17 PM
  2. User form to add attachments and send the form and attachments via outlook
    By scorchio83 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2013, 03:46 AM
  3. Drop-down Form Field launching another form
    By aCmE in forum Word Formatting & General
    Replies: 0
    Last Post: 12-23-2010, 08:56 AM
  4. Need advice on Outlook form.
    By ali84pk in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 12-21-2010, 11:53 AM
  5. [SOLVED] Excel form in Outlook
    By Bas Harnas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2005, 03:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1