Excel Userform Dropdown List - Get data from all columns?

Question

I created a userform with a combo dropdown list. I got it to work in general.

My issue is, is that I can only bound it to one column from what I can tell. In the screenshot for example has 3 columns. Is there a way to pull all 3 columns? perhaps enter them in a text box in the userform?

Thank you!

Userform Dropdown Screenshot

I've only tried to play with the BoundColumn properties, I don't know how else to achieve it what I am looking for.

Properties Screenshot

Please share the relevant (best complete) code and a detailed description of how it fails. — VBasic2008
– VBasic2008, Commented Dec 4, 2024 at 17:48

TinMan · Accepted Answer · 2024-12-04 17:55:59Z

1

We can access the ComboBox data using its List and use its ListIndex property to get the current row of data.

Private Sub ComboBox1_Change()
    With ComboBox1
        Debug.Print .List(.ListIndex, 0), .List(.ListIndex, 1), .List(.ListIndex, 2)
    End With
End Sub

answered Dec 4, 2024 at 17:55

TinMan

7,8142 gold badges13 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

Excel Userform Dropdown List - Get data from all columns?

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