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. #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.

  3. #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
  •