Form In .xla file

[Mike H.]

How do I reference a form that is located in an add-in xla file? The name of
the xla file is dailymods.xla so I tried:
dailymods.userform2.show
but it doesn't work. Ideas?

 

[Joel]

Is the form opened?

try something like this
workbooks.open filename:=dailymods.xla 'include path if necessary
set frm = ActiveWorkbook 'reference for by this name or
'Workbooks("dailymods.xls")
'when using workbooks don't include
path

 

[Mike H.]

I tried this but it doesn't work:
Set Frm = Workbooks("dailymods.xla")
Frm.UserForm1.Show

I am not sure I am understanding your suggestion.

 

[Peter T]

In your dailymods.xla Include a sub or function to show the form, it
probably already has one, eg

Function RunForm(a As String) As Variant
UserForm1.Caption = a
UserForm1.Show
RunForm = "Return value"
End Function

One way to call RunForm from other projects is with 'Run', eg

Sub test()
Dim s As String, res
s = "called from " & ThisWorkbook.Name
res = Application.Run("dailymods.xla!RunForm", s)
MsgBox res
End Sub

Regards,
Peter T

 

[Mike H.]

That worked! Thanks.

In your dailymods.xla Include a sub or function to show the form, it
probably already has one, eg

Function RunForm(a As String) As Variant
UserForm1.Caption = a
UserForm1.Show
RunForm = "Return value"
End Function

One way to call RunForm from other projects is with 'Run', eg

Sub test()
Dim s As String, res
s = "called from " & ThisWorkbook.Name
res = Application.Run("dailymods.xla!RunForm", s)
MsgBox res
End Sub

Regards,
Peter T

 

[Mike Reynolds]

How do I reference a form that is located in an add-in xla file?

In a similar vein, but a little more basic, how do you create a form in VBA,
or in Visual Studio and import it through VBA?