Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export Userform to another user (2002 SR2)

    Under Outlook I have created a Userform with a simple control on it. <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

    I can pass macro code to another user by cut and paste.
    What process do I use to transfer the Userform?
    Maybe its the way I hold my tongue - but export from me and import by him didn't seem to work. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Export Userform to another user (2002 SR2)

    It is export/import, but there are two files (UserForm1.frm and UserForm1.frx). Make sure your form actually has a unique name before exporting, because otherwise the VB Editor will improvise a new name (e.g., UserForm11) that won't match up with your code.

  4. #3
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export Userform to another user (2002 SR2)

    Jefferson
    Thanks - yes - I'd missed that second file. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

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