combobox selection to textbox in userform

[rharri1972]

Hello!
I have a userform with a combobox1 and I am attempting to have information from the range of cells in the worksheet populate textboxes on the same userform.

I am trying with only one textbox at the moment and figured once I get the code right I should be able to add the others.

Here is the code that i found on Google that keeps returning cannot get the vlook up property of the worksheet function class:


Private Sub UserForm_Initialize()
Dim xRg As Range
Set xRg = Worksheets("Customers Select").Range("A2:G1000")
Me.ComboBox1.List = xRg.Columns(1).Value

End Sub

and for the combobox1

Private Sub ComboBox1_Change()
Me.TextBox13.Text = Application.WorksheetFunction.VLookup(Me.ComboBox1.Value, xRg, 2, False)


End Sub

Any help please?

 

[My Aswer Is This]

Hello!
I have a userform with a combobox1 and I am attempting to have information from the range of cells in the worksheet populate textboxes on the same userform.

I am trying with only one textbox at the moment and figured once I get the code right I should be able to add the others.

Here is the code that i found on Google that keeps returning cannot get the vlook up property of the worksheet function class:


Private Sub UserForm_Initialize()
Dim xRg As Range
Set xRg = Worksheets("Customers Select").Range("A2:G1000")
Me.ComboBox1.List = xRg.Columns(1).Value

End Sub

and for the combobox1

Private Sub ComboBox1_Change()
Me.TextBox13.Text = Application.WorksheetFunction.VLookup(Me.ComboBox1.Value, xRg, 2, False)


End Sub

Any help please?

This looks like the same question you asked earlier and I gave you a script.
But in your first posting you said load all the values in the range to Combobox1

 

[rharri1972]

This looks like the same question you asked earlier and I gave you a script.
But in your first posting you said load all the values in the range to Combobox1

a little different... now that i have the combobox listed correctly I now need to know how to send values to different textboxes...I need the values in the combobox because i have same customer in different locations so i need to make sure i am selecting the correct customer name and location. Then I need to have the values that are related to the selected customer populate mulitple different textboxes on the userform. I am trying to do this step by step as to not have an over abundance of information as I go. It also helps me learn step by step.

 

[My Aswer Is This]

I'm going to move on and let someone else help you.

 

[Fluff]

Duplicate to: combo box selection

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.