| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form In .xla file
That worked! Thanks.
"Peter T" wrote: 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." wrote in message ... 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA open file from a form | Excel Discussion (Misc queries) | |||
| Call user form from ThisWorkbook; close file if form closed | Excel Programming | |||
| File in 2007 form - need to get back to 2003 form... | Excel Discussion (Misc queries) | |||
| Open file from a form | Excel Programming | |||
| Excel-Form to file.txt | Excel Programming | |||
Threaded Mode
