Results 1 to 5 of 5

Thread: Exporting Userform design and code to import in VB

  1. #1
    New Member lockarde's Avatar
    Join Date
    Oct 2016
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Exporting Userform design and code to import in VB

    Hello all,

    I've recently created a userform within excel to take care of some quick calculations I regularly have to do. After getting it all set, I thought, why not make it a stand alone app, instead of having to run excel everytime? I tried exporting the userform, and I get two files, one .frm file, and one .frx file. I can import the .frm file just fine into VB, but it doesn't seem to bring in the useform design, just the code. I was hoping someone might have run into this issue in the past.

    Thanks for the help!

  2. #2
    Board Regular NdNoviceHlp's Avatar
    Join Date
    Nov 2002
    Location
    Manitoba Canada
    Posts
    2,285
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Exporting Userform design and code to import in VB

    Unfortunately lockarde, you need to operate XL to operate the VBA required for the userform… U can't have the userform as a stand alone program. HTH. Dave

  3. #3
    New Member lockarde's Avatar
    Join Date
    Oct 2016
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Exporting Userform design and code to import in VB

    Quote Originally Posted by NdNoviceHlp View Post
    Unfortunately lockarde, you need to operate XL to operate the VBA required for the userform… U can't have the userform as a stand alone program. HTH. Dave
    Thanks for the reply! So it seems I just need to remake the form, and alter the code to fit the syntax of VS?

  4. #4
    Board Regular NdNoviceHlp's Avatar
    Join Date
    Nov 2002
    Location
    Manitoba Canada
    Posts
    2,285
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Exporting Userform design and code to import in VB

    Yes I believe that is your only option. Dave

  5. #5
    New Member lockarde's Avatar
    Join Date
    Oct 2016
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Exporting Userform design and code to import in VB

    Quote Originally Posted by NdNoviceHlp View Post
    Yes I believe that is your only option. Dave
    Welp, you gotta do what you gotta do! Thanks for the help Dave

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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