Excel VBA - How to Add TextBox to UserForm Programatically

Excel VBA Learn how to add TextBox to UserForm programatically

The code used in this video:

Private Sub UserForm_Initialize()
Dim cTextBox As Control
Set cTextBox = Controls.Add("Forms.TextBox.1")
With cTextBox
.Height = 30
.Width = 200
.Top = 20
.Left = 20
End With
End Sub

[jorgetaco]

good, thanks, congratulation from Ecuador, Quito

[matt]

This is extremely helpful. Clear, concise and to the point.

[uniQue_XL]

Thanks for the great video !
after I've added the controls ass you explain, how do I pass the values in the controls into the worksheet ?

[tymussh]

How can I create these Control Boxes in Userform with multiple pages?
Also how do create permanently (means, if I close the userform, control boxes stay with the userform next time I open?)

[ksnarayanan]

How to include a combo box in excel userform of 60 records? Thanks for your advice in advance.