Create Userform on the Fly?

PA HS Teacher

Well-known Member
Joined
Jul 17, 2004
Messages
2,838
Is it possible to create a userform on the fly?

I know how to create controls on the fly.
e.g.
Set ctl = MyForm.Controls.Add("forms.CommandButton.1")

But what if I wanted to create MyForm on the fly?
 
One issue I can ask you help on is how to wrestle with/ where to store some preferences. I also want the ability to "export" a lessonplan to word. I want to be able to control how the lesson plan is presented. (both on a form and in the word document. I want to be able to control the order in which I present the Section, whether or not it contains a Header, Is the Header Bold, but most importantly the Sequence in which the Sections are presented. (and may need a few non generic sections, e.g. for Objectives, because the generic section object doesn't quite accomodate the the way we write objectives at this school) But if I have these additional specifically created objects. (which would be at an equal level on the tree of objects to the generic Section object) I want to be able to order them too. And I want to make sure these custom objects, there wouldn't be many, don't disrupt our object structure.

All I can say Dan is that you need to ask yourself what your objects need to know in order to perform all of these various operations...
 
Upvote 0

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Forum statistics

Threads
1,216,031
Messages
6,128,422
Members
449,450
Latest member
gunars

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top