How to output a variable from dynamically created vba userform textbox

Question

hopefully I am asking the correct question. I have a userform that displays X number of text boxes when initialized. here is a snippet:

Dim MF As Object

Set MF = Me.Controls.Add("Forms.TextBox.1", "BoxNumber_" & i, True)
    With MF
        .Value = ""
    End With

??? msgbox Me.MF.BoxNumber_i.value

Once a user is finished filling out the userform it will eventually write the results to SQL. my question is.. how do I output the variable MF.BoxNumber_i.value once the user fills this out?

Orin Moyer · Accepted Answer · 2015-11-24 14:16:05Z

1

Found it, figured I would post the solution in case someone stumbles across this one day.

msgbox Me.Controls("BoxNumber" & i).value

answered Nov 24, 2015 at 14:16

Orin Moyer

5092 gold badges7 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

How to output a variable from dynamically created vba userform textbox

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related