LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Form Creation

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
form creation Roy Gudgeon[_2_] Excel Discussion (Misc queries) 1 March 4th 10 12:59 PM
Form Creation in Excel 2007 Stan Clawson Excel Discussion (Misc queries) 2 March 19th 07 06:10 PM
Macro for Multiple Form Creation JB2010 Excel Discussion (Misc queries) 1 March 23rd 06 03:56 PM
form creation Peter Bailey[_2_] Excel Programming 4 November 7th 04 08:23 PM
Can Excel use as a VB form creation? tanks1308[_3_] Excel Programming 5 August 17th 04 04:49 PM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"