load userform from other VBProject (Excel 2000)
"Fero Bokor" wrote in message
...
Hi all,
is it possible to load (to show) a UserForm from other VBAProject ?
There is a Reference between ActiveVBProject and the other VBAProject .
Thanks a lot ...
Fero
Not directly but you can call a procedure in code module in that
other workbook which shows the form
Example
In Project A you have a form called MyForm
Create a code Module called MyCode and add the
procedure
Public Sub ShowMyform
MyForm.Show
End Sub
In Project B after you have set a reference you
can say
A.ShowMyform
Keith
|