Pages 804-805 of John Walkenbach's Excel 2002 Power Programming book has an
example of how to programmatically create a Userform.

I've done that in both Excel and word, but I'm now trying to create the
Userform via automation in VB 6.

No problem creating/removing the Userforms, however, how does one display
the Userform when running the code from within VB 6?

The VBA library for VB does not have a Userform object so the following
fails:

VBA.UserForms.Add(TempForm.Name).Show

Thee following does output the correct Userform name, where ExcelProject is
set as wkbExcel.VBProject, where wkbExcel is an Excel Workbook.

Debug.Print ExcelProject.VBComponents(TempForm.Name).Name

Any pointers to info?
--
http://www.standards.com/; See Howard Kaikow's web site.