Jezebel or other helper

S

singeredel

Hi,

I was wondering if you would take a look at my prior post "How to reference
Userform in another project." I have responded to your suggestion but still
need help.

Thank you!
 
J

Jezebel

OK, here's one way to do it --

In Hannani_Test, add a module (or use an existing module if there is one).
Add this code --

Public Property Get ReportForm() as frmCreate_Hannani_Report
Set ReportForm = new frmCreate_Hannani_Report
End Property


Then in the calling project, use --

Sub Test()

With Hannani_Test.ReportForm
.txtReportDateMonth = "02"
:
.Show
End with
End Sub
 
S

singeredel

Thank you SO MUCH for answering so promptly. It finally works! The only
change I had to make to get it to run was to change Hannani_Test.ReportForm
to just Hannani.ReportForm. (from referencing the Template to referencing the
Project)

A hundred thanks again!
 
Top