Loop for creating textbox

[murid]

Hi,

I would be very thankfull if someone could tell me how can I create textbox by using loop. All thanks in advance for your input and help.

Regards

[davegugg]

You don't need a loop to create a text box.
Use the macro recorder and look at the code it gives when you place a TextBox.

[6StringJazzer]

I am assuming you mean the graphical object textbox, rather than the textbox form control.

You have not provided enough information to describe what you need but the code below will create multiple textboxes in a loop on a worksheet. The boxes will be 200 x 50 with vertical space of 10 in between.

Please Login or Register  to view this content.

[6StringJazzer]

You don't need a loop to create a text box.
Use the macro recorder and look at the code it gives when you place a TextBox.

Funny thing, that. I did that and it didn't generate any code. I created a textbox, added text, and then selected a cell. The only thing the macro recorder included was the cell selection.

[davegugg]

Interesting, I did it before my first post in 07 and it gave me:

Please Login or Register  to view this content.

[murid]

Hi Guys,

Sorry for not providing more information on my request. Actually I'm trying to create comand button in form wil allow me to generate a textbox control (Forms) by using loop.

Thanks

[6StringJazzer]

Interesting, I did it before my first post in 07 and it gave me:

I will just assume I had an ID-10-T error.

[6StringJazzer]

Hi Guys,

Sorry for not providing more information on my request. Actually I'm trying to create comand button in form wil allow me to generate a textbox control (Forms) by using loop.

Thanks

This might be possible (I've never done it and I couldn't figure it out in 5 minutes) but I suspect there is a better way to do whatever it is you want to do. Dynamically modifying form elements is not an ideal programming practice, because it's tricky to reference them, and you can easily develop problems if you try to reference things before you create them. And what if you need to delete them later?

What are you trying to do? You might be better off anticipating what text boxes you might need, then controlling whether they are visible or not based on user activity.

[6StringJazzer]

Interesting, I did it before my first post in 07 and it gave me:

You created a textbox control. I created a textbox shape, as I had assumed in an earlier post. (However turns out the OP wants a control.) Nonetheless, it's odd that the macro recorder won't show creation of a textbox shape.

[murid]

Salam,

The solution below

Private Sub CommandButton1_Click()

Dim control1(4) As Control
Dim y As Integer
y = 0

For i = 1 To 4
Set control1(i) = UserForm1.Controls.Add("Forms.TextBox.1", "mytextbox", True)

control1(i).Top = 100 + y
control1(i).Left = 100
control1(i).Width = 50
control1(i).Height = 50

y = y + 50

Next i

End Sub