advanced filter information into a combo box for selection

C

Cheryl

I have extracted information using a macro with worksheet_change

If Target.Address = "$b$25" Then
'calculate criteria cell in case calculation mode is manual
wsData.range("t2").Calculate
wsData.range("PartsDatabase") _
.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=wsData.range("t1:t2"), _
CopyToRange:=range("C25:G25"), Unique:=False
End If

I want that information to be part of a combo/list box so that the customer
can choose it as part of their order based on criteria they are searching
for. I know there is a way.. but I just can't find where I found the
solution once before. Kind of like searching by material, then because there
are many of the same type of material.. filtering out just those records
that meet the criteria and have them appear in the combo box where the user
can then choose from just those records that appear.

Thanks in advance for your assistance.
 
Top