creating a userform, a frame and a label using VBA codes alone.

[josaah]

Hello,Friends, how do I create an excel userform, a frame and a label and add the frame to the userform and the label to the frame using excel vba codes not prefabricated ones?

[mikerickson]

Its not really a good idea to create user form's or controls on the fly.

What is your situation and why won't a userform created at design time suit your purpose?

[josaah]

I'd like to duplicate the frames and label so I load information on each of them. The frame s will then have unique ids which I could assign to cells for riddles I'm creating.handling several prefabricated frames within the userform becomes difficult since the frames are large and cover one another.