Populating Textboxes in a Userform

[TheKernz]

Hey everyone,
I'm trying to figure out how to open a userform with textboxes already filled in based on values in a cell range. I can't seem to figure this out for the life of me.
Thanks

 

[Gavin T]

Paste the code in the form's code so it can run on the event when the form is initialized (right-click on the form object and select "View Code").

Private Sub UserForm_Initialize()

    TextBox1 = "I'm filled in"
    TextBox2 = "I'm also filled in "

End Sub

 

[TheKernz]

My problem is that the textboxes change which cells need to be referenced depending on which command button in my sheet has been pressed. Is there anyway to write the userfrom_initialize in another sub?
Thanks

 

[Gavin T]

There are a variety of event handling procedures. What you want is the Button_Click event.

Private Sub CommandButton1_Click() [COLOR="#008000"]' This runs when "Button1" is clicked[/COLOR]
    TextBox1 = Range("A1")
    TextBox2 = Range("A2")
End Sub

Private Sub CommandButton2_Click() [COLOR="#008000"]' This runs when "Button2" is clicked[/COLOR]
    TextBox1 = Range("B1")
    TextBox2 = Range("B2")
End Sub

 

[TheKernz]

There are a variety of event handling procedures. What you want is the Button_Click event.

Private Sub CommandButton1_Click() [COLOR=#008000]' This runs when "Button1" is clicked[/COLOR]
    TextBox1 = Range("A1")
    TextBox2 = Range("A2")
End Sub

Private Sub CommandButton2_Click() [COLOR=#008000]' This runs when "Button2" is clicked[/COLOR]
    TextBox1 = Range("B1")
    TextBox2 = Range("B2")
End Sub

That's what my code originally was, however it does not populate the textboxes. Any other suggestions? To me I think I need something that initializes the userform. I tried putting the above code in with a userform.show but to no avail. An in code userform_initialize to me seems the way to do it, only I don't know if such a piece of code exists.

 

[Gavin T]

The code I provided in Post #4 should populate the textboxes with the values in cells A1 & A2 or B1 & B2 when you press the buttons. It will work if all of these conditions are met:

1. You have two buttons on your form named "Button1" and "Button2"
2. You have two textboxes named "TextBox1" and "TextBox2"
3. The code is pasted in the form's code window