Brett Scott
New Member
Hello,
I currently am trying to populate a listbox based off a combobox selection. my setup is currently this:
Sheets("Sheet1").range("A1") = Combobox1.value
i then have an array formula in B3 that equals=
{=SMALL(IF(AgentInfo[Unit]=$A$1,ROW(AgentInfo[Unit])),ROW(1:1))}
from this formula in cell B3, i have an index, Match formula in row C3 that starts matching info to populate a list.. all based off the combobox value shown in A1=
=IFERROR(INDEX(AgentInfo[Unit],MATCH(B3,AgentInfo[Row'#],0)),"-")
This formula is then dragged down to row 75. This formula will populate different data based on A1.
Now im trying to populate the listbox and the listbox is capturing all the rows that include "-" instead of just the data.
how would i exclude the "-"'s in the rows?
here is my current formula:
I currently am trying to populate a listbox based off a combobox selection. my setup is currently this:
Sheets("Sheet1").range("A1") = Combobox1.value
i then have an array formula in B3 that equals=
{=SMALL(IF(AgentInfo[Unit]=$A$1,ROW(AgentInfo[Unit])),ROW(1:1))}
from this formula in cell B3, i have an index, Match formula in row C3 that starts matching info to populate a list.. all based off the combobox value shown in A1=
=IFERROR(INDEX(AgentInfo[Unit],MATCH(B3,AgentInfo[Row'#],0)),"-")
This formula is then dragged down to row 75. This formula will populate different data based on A1.
Now im trying to populate the listbox and the listbox is capturing all the rows that include "-" instead of just the data.
how would i exclude the "-"'s in the rows?
here is my current formula:
Code:
With Sheets("Attendance")
ListBox2.RowSource = Range(.Range("D3:E3"), .Cells(Rows.Count, "D").End(xlUp)).Address(, , , True)
End With