Howto Show importerd userform

[Raymond]

Hi

I want to make a excel sheet that imports an userform and then show th
imported userform.

Has anyone an idea how i can do that.

Greetings Raymon

 

[Bob Phillips]

Raymond,

This shows you hoe

ThisWorkbook.VBProject.VBComponents.Import _
Filename:="C:\myTest\frmWizard.frm"

Call show



Sub show()
frmWizard.show
End Sub

Note that the code to show the form must be in a separate procedure,
otherwise yuou will get a run-time error as the form will not exist at that
point.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)