Export VBA forms

[alonzo51087]

Is there any way to export a vba form to an application file or have the UserForm run on its own instead of through Excel?

 

[SkipVought]

Hi,

You can EXPORT a Form to a .frm file.

However, it can only be manipulated (displayed & run) with the appropriate MS application like Word, Excel, Outlook, Powerpoint, Access or complied into an .exe in Visual Basic n.m

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[FaneDuru]

Sub Exp()
 On Error Resume Next
  ActiveWorkbook.VBProject.VBComponents.Remove _
             ActiveWorkbook.VBProject.VBComponents.Item("UserForm1")
 On Error GoTo 0
 ThisWorkbook.VBProject.VBComponents("UserForm1").Export "UserForm1.frm"
 ActiveWorkbook.VBProject.VBComponents.Import ("UserForm1.frm")
 Kill ("UserForm1.frm")
End Sub

Exporting and inporting a form.
Fane Duru