Howto Show importerd userform

  • Thread starter Thread starter Raymond
  • Start date Start date
R

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
 
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)
 
Back
Top