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

load userform from other VBProject (Excel 2000)
 

It works ...
Thanks, Keith
Fero