Userform to input value from worksheet after name has been selected

[ipbr21054]

Hi,
I would like to select a name in my TextBox userform & have other values taken from worksheet database & populate other Textboxes on the userform.

Some info for you.
Userform is called ADD CUSTOMER
Worksheet is called G INCOME
Userform TextBox1 is NAME
Userform TextBox2 is ADDRESS
Userform TextBox3 is POST CODE
Userform TextBox4 is MILES

My databse is currently U4:X21 but will carry on down the page
Column U is NAME
Column V is ADDRESS
Column W is POST CODE
Column X is MILES

So it should work like this.
On the userform clicking TextBox1 NAME drop down arrow i then see the customers that are in my database in column U
I select a customer & i see his name now appear in TextBox1
Also i should see the other TextBoxes 2,3 & 4 prefilled with the values taken from database columns V,W & X

 

[ipbr21054]

@Fluff please can you advise on this.

I have found an old post & used the code.
Here is the post.

VBA Textbox populate base on combobox selection

Please sir i wrote a code on my user form to populate a text box based on combo box selection but the text box isn't show anything. this is the code on user form initialize: dim i as long, lastrow as long, ws as worksheet set ws = Sheets ("Sheet1") Lastrow = ws.Range("A" &...

www.mrexcel.com

Here is what i have & fills my Textboxes all fine

   Private Sub ComboBox1_Click()
   Me.TextBox2.Value = Sheets("G INCOME").Range("V" & Me.ComboBox1.ListIndex + 4).Value
   Me.TextBox3.Value = Sheets("G INCOME").Range("W" & Me.ComboBox1.ListIndex + 4).Value
   Me.TextBox5.Value = Sheets("G INCOME").Range("X" & Me.ComboBox1.ListIndex + 4).Value
   End Sub

Then i have this & it popultes the ComboBox BUT im not sure what i should be using where in the other persons code A is used

    With Sheets("G INCOME")
      Me.ComboBox1.List = .Range("U4:U" & .Range("A" & Rows.Count).End(xlUp).Row).Value
    End With