Build userform on-the-fly

I'm trying to build an Excel userform on-the-fly.
I wanted to put 2 columns side-by-side down the form.
The first column is a label and the second column is a textbox.

The label and textbox data are column A and column B in a worksheet.

label1 textbox1
label2 textbox2
label2 textbox3
label3 textbox4

Any code or tips/pointers on this?

Thanks,

Thanks - I'll have a look.

The solution depends on what you want to do with the userform.
Enter data to rows of a worksheet I suppose.
In this case, try to copy the following code on the userform, place a Scrollbar1, a Spinbutton1, three CommandButtons on the form, plus your labels and TextBoxes as you described above.
To load the UserForm you need an aditional macro on a normal modul.
Cheers, Gabor

Please Login or Register  to view this content.

Gabor,

Thanks for the code snippet - a few mods and it was exactly what I wanted.

Thank you.

Though this is a good solution, it woudl be better if I could add the "label field" and the "text box field" programatically on the userform. The solution above makes me create the form ahead of time AND add all the fields ahead of time. If my data changes, I'll have to edit the userform.....

I have some code that adds textfields to a userform within a frame - my issue with the code is "placement" of the field - it adds the fields directly on top of one another. I do not know how to place them correctly so they are in a column. There must be some x,y placement for the text box.

One last item, I want to add Labels also, what is the name of that control type?

Any help is appreciated.

Thanks,

Sub AddTextbox(box)
Dim fr As Frame
Dim Txt As Control

Set Txt = Me.Frame1.Controls.Add("Forms.TextBox.1")

Txt.Name = "Box" & box
Txt.TabStop = True

End Sub

Of course, as soon as I ask for help I find out how to perform the task.
Just use the properties of the object to arrange them accordingly.

Sub AddTextbox(box)
Dim fr As Frame
Dim Txt As Control

Set Txt = Me.Frame1.Controls.Add("Forms.TextBox.1")

Txt.Top = Top
Txt.Left = Left
Txt.Width = Width
Txt.Height = Height

Txt.Name = "Box" & box
Txt.TabStop = True
End Sub

Building on your idea, or demand, maybe we should try to come up with a utility that asks the user to select what the type of the next control is to be (TextBox, Combobox, OptionButton, etc.) and so step-by-step the user would be able to build up the rough form that then could be easily customised further, re-sized, finalised within VBE.
What do you think?
Gabor

Sounds like a great utility that could help many - maybe in a little bit though, I'm swamped at the moment...

Hi, guys!

Can UserForm be created only by code during macro excution, not with VB editor Isert->UserForm?

Sorry for the stupid question, but I'm just starting to work with Excel VB.

Yours, Boyko.

UF-s are created in VBE primarily, however as posted by JWM6 it is possible to be done by code ??
But since this is very cumbersum either ways a UF Wizzard would be of a great help.
Does Anyone know such a feature somewhere on the net?

Gabor

Great queston, in my example, I already had the userform created. I have not investigated whether or not he userform can be created by VB code.