Creating and using textboxes runtime

[yk01]

Does anybody know, how I can create a userform with textboxes at runtime (not designtime), and how I can finally read (variables) and process the text the user types into the boxes?

I would be happy about any answer I get because the way I tried doing the mentioned task is causing big problems.

 

[SkipVought]

Hi,
I don't think that there is a way to add controls to a userform at run time. Controls can be added to a worksheet at run time.

The general form of accessing data from textboxes is ...

    With UserForm1
        sVariable1 = .TextBox1
        sVariable2 = .TextBox2
'-- etc
    End With

Skip,
metzgsk@voughtaircraft.com