Excel VBA Userform using vlookup

Question

I have a userform with 1 combobox and 3 textboxes. I want to use vlookup to display the values in the texboxes based on the selection in the combobox. The first textbox works but after that it gives errors. Pls help. Here is my code:

Private Sub ComboBox1_Change()
    Description = Application.VLookup(ComboBox1.Value, Range("A1:B17"), 2, 0)
    TextBox1.Value = Description
    Platform = Application.VLookup(ComboBox1.Value, Range("A1:B17"), 3, 0)
    TextBox2.alue = Platform
End Sub

this part Application.VLookup(ComboBox1.Value, Range("A1:B17"), 3, 0) returns an error, since you want to return the 3rd column, when you defined the range with only 2 columns (` Range("A1:B17")`) — Shai Rado
– Shai Rado, Commented Jul 27, 2017 at 7:06
Also, you have typing error: TextBox2.alue = Platform - you missed 'V' in Value. — Michał Turczyn
– Michał Turczyn, Commented Jul 27, 2017 at 7:17
Please do some basic error checking before posting a question here. Your problem arises simply because you have typos in your code. Voting to close this question as low quality. — teylyn
– teylyn, Commented Jul 27, 2017 at 7:23

Vityata · Accepted Answer · 2017-07-27 08:29:03Z

1

As mentioned in the comments when you refer to 3. column, you should have at least 3 columns in your range. Read more about VLookup here.

Try like this:

Private Sub ComboBox1_Change()

    Description = Application.VLookup(ComboBox1.value, Range("A1:C17"), 2, 0)
    TextBox1.value = Description
    Platform = Application.VLookup(ComboBox1.value, Range("A1:C17"), 3, 0)
    TextBox2.value = Platform

End Sub

answered Jul 27, 2017 at 8:29

Vityata

43.8k10 gold badges64 silver badges110 bronze badges

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

Collectives™ on Stack Overflow

Excel VBA Userform using vlookup

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