Delete Userform Control with VBA.

[AlexanderBB]

Is this possible?
I found some details here (msg #9) Programmatically remove a control from userform but it wouldn't work for me.
I tried and got Run-time error '-2147024809 (80070057)': Invalid argument.

    With myForm
        .Controls.Remove "imgPlay0b"
    End With

I have a Userform with 102 controls so some are hard to find. But I do have all their names.

 

[Legacy 456155]

You do understand that you can only remove controls that are created in run-time. Right? If imgPlay0b originates from design time, you cannot remove it in run-time.

 

[AlexanderBB]

Ok didn't know that... thanks.

 

[Legacy 456155]

It's no problem for you. Just add the control in the Initialize event and then delete it when your done with it. Frankly, unless you are dealing with many controls, just changing the visibility might do well enough.

 

[Jaafar Tribak]

are you adding the controls at runtime ?

 

[AlexanderBB]

No, I've added all the controls at run time, so they're very hard to find (the way I've done it) with some hidden under Frames etc. So I was hoping to redesign it.

 

[AlexanderBB]

Is there any overhead to adding controls at run time? I'm going to try it out and have this code:

Set cControl = myForm.Frame1.Controls.Add("Forms.Label.1", "lbl" & Num, False)
    With cControl
        .Width = 42
        .Height = 12
        .Left = 6
        .Font.Name = "Tahoma"
        .Font.Bold = True
        .AutoSize = False
        .WordWrap = True
        .Font.size = 8.25
    End With

Can the above be used for any control, and could someone confirm the progID parameter? I'm can't figure what the ".1" is and I presume Forms.Label means its a label on a Form? Thanks.

 

[Legacy 456155]

Is there any overhead to adding controls at run time? I'm going to try it out and have this code:

I don't know. I do know that I once did a project for a client that did not have Access but wished to emulate Access' continuous forms. I was able to do it using MSForms, adding quite a few controls at run-time without any issues.