Hi All,
I am working on Activex Combobox which is located in "Dashboard" sheet wherein I want to display dynamic range from another sheet called "Filters"
I have created the dynamic range in "Filters" A Column using the Filter function.
Also, I have VBA (pasted below) but this VBA is referencing in "Dashboard" sheet whereas i want it from Filter Sheet, is there any trick which we can use to populate data.
Private Sub Region_L_Change()
Dim Rng As Range
Set Rng = Range(Range("A2"), Range("A" & Rows.Count).End(xlUp))
Region_L.ListFillRange = Rng.Address
Region_L.ListIndex = 0
End Sub
I am working on Activex Combobox which is located in "Dashboard" sheet wherein I want to display dynamic range from another sheet called "Filters"
I have created the dynamic range in "Filters" A Column using the Filter function.
Also, I have VBA (pasted below) but this VBA is referencing in "Dashboard" sheet whereas i want it from Filter Sheet, is there any trick which we can use to populate data.
Dashboard Latest .xlsm | |||
---|---|---|---|
A | |||
1 | Region | ||
2 | East | ||
3 | North | ||
4 | South | ||
5 | West | ||
Filters |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A2:A5 | A2 | =SORT(UNIQUE(FILTER(ASC_List[Region],ASC_List[Region]=ASC_List[Region])),) |
Dynamic array formulas. |
Private Sub Region_L_Change()
Dim Rng As Range
Set Rng = Range(Range("A2"), Range("A" & Rows.Count).End(xlUp))
Region_L.ListFillRange = Rng.Address
Region_L.ListIndex = 0
End Sub