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

--
Message posted from http://www.ExcelForum.com

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)

"Raymond " wrote in message
...
Hi

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

Has anyone an idea how i can do that.

Greetings Raymond


---
Message posted from http://www.ExcelForum.com/