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
