View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keith Willshaw Keith Willshaw is offline
external usenet poster
 
Posts: 170
Default 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