Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Creating and using textboxes runtime
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.- yk01
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Public Array of Type 'Control' in userforms
I've generated a userform with textboxes inserted in runtime. Following Syntax: Public MyTextBoxes(20) As Control ... Set UF1 = ThisWorkbook.VBProject.VBComponents.Add(vbext_ct_MSForm) ... Set MyTextBoxes(TBCount) = UF1.Designer.Controls.Add("Forms.TextBox.1") After (means really...- yk01
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
