Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm unsure how to proceed with the following task:
What I'd like to do is to create a class that can if needed create and display an Excel Userform. I've tried adding a reference to the Forms Object Library and then creating an object reference of type Userform in my class, e.g. dim frmMyForm as Userform The compiler accepts that but does not accept: Set frmMyForm = New Userform In addition, Intellisense does not offer a Show method for frmMyForm generating an error if I write Public Sub ShowMyForm() frmMyForm.Show End Sub Can anyone point me to a source of enlightenment? Thanks William |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
form creation | Excel Discussion (Misc queries) | |||
Form Creation in Excel 2007 | Excel Discussion (Misc queries) | |||
Macro for Multiple Form Creation | Excel Discussion (Misc queries) | |||
form creation | Excel Programming | |||
Can Excel use as a VB form creation? | Excel Programming |