Exporting Userform design and code to import in VB

lockarde

New Member
Joined
Oct 23, 2016
Messages
25
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!
 

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
2,317
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
 

lockarde

New Member
Joined
Oct 23, 2016
Messages
25
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?
 

Forum statistics

Threads
1,078,314
Messages
5,339,437
Members
399,305
Latest member
msklut

Some videos you may like

This Week's Hot Topics

Top