Searching table column for a value and populating an array with the matching row contents

Matt W · Dec 12th 2020

Okay, but when looping through, how do I identify the selected item of the combo box list?

Fluff13 · Dec 12th 2020

With

Code

Me.cbChooseGroup.Value

Matt W · Dec 12th 2020

I simply can't get that to work. I have to be missing something. Can you put that in the example file and show me that section of the code? I fear I'm over complicating things.

Fluff13 · Dec 12th 2020

How about

Code

                    g = Me.cbChooseGroup.List
                    For i = 0 To UBound(g)
                        If g(i, 0) = Me.cbChooseGroup.Value Then
                           wksDest.Range("GroupImportRange").Resize(, 8).Value = Application.Index(g, i)
                           Exit For
                        End If
                     Next i

Matt W · Dec 12th 2020

Boom. That's it! Only thing I noticed is that (other than if the first or top item is selected), the output to the range is one-off from the item selected.

Fluff13 · Dec 12th 2020

In that case add 1 to i in the index

Matt W · Dec 12th 2020

That's perfect!! All elements function properly. You've been a huge help in advancing my efforts. Many thanks!

Fluff13 · Dec 12th 2020

You're welcome & thanks for the feedback.

Searching table column for a value and populating an array with the matching row contents

Participate now!

Share

Users Viewing This Thread