Speed up Frame1.Clear???

[jackass209]

I have a Frame on a UserForm. The Width of the frame depends on values given in TextBox.Dat1 and TextBox.Dat2.

Now I tried it with a width of 2200 with a scroll bar, but when I change the value in the Textboxes I need the Frame to be cleared. Now this is my question. I use "UserForm1.Frame1.Clear" but this can take up to 1 minute.

Is there anyway to speed this up???

Hope someone can help me.
Thanks in advance!

 

[jackass209]

I'm trying right now to add a new frame over the old one.
Only question is how to add the labels to the new frame.

The new frame name is "Frame" & sh1.Range("X6")

But how to add the label?

Set MyControl = RegRap.Frame & sh1.Range("X6").Controls.Add("forms.Label.1")

This won't work... any idea?

 

[jackass209]

Nevermind. Got this working.

Set MyControl = RegRap("Frame" & sh1.Range("X6")).Controls.Add("forms.Label.1")

this did the trick.

Thanks alot for your help Richard!