Excel VBA Get adjacent userform control value

Question

I have a userform with several rows of textboxes. As I loop through the controls, I'm concatenating the textbox values for a final string. Rather than looping through every textbox, I am only looping through the first textbox in the row and trying to assign a value to a variable with the replace method.

What I've tried: TBvalue = Replace(ctl.Name, "Textbox1", "Textbox2")

followed by TBvalue2 = OnboardingLogForm.TBvalue.value

Also tried: TBvalue = OnboardingLogForm.Textbox & i.value when iterating with i

How can I get the values of other textboxes without statically referring to them?

Perhaps useful? stackoverflow.com/questions/51750281/…, or maybe ozgrid.com/VBA/control-loop.htm — BigBen
– BigBen, Commented Oct 28, 2019 at 20:15

W-hit · Accepted Answer · 2019-10-30 20:26:30Z

1

Found an answer. Thanks for your help.

Me.Controls("TextBox" & i).value

Or, if there's any number order to your control names, you can try:

For Each ctl In Userform1.MultiPage1.Pages(0).Controls
    blah = Me.Controls(Replace(ctl.Name, "TextBox1", "TextBox2")).value
Next

edited Oct 30, 2019 at 20:26

answered Oct 28, 2019 at 20:25

W-hit

3615 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel VBA Get adjacent userform control value

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related