Dear Forum Folk,
I have below a VBA script thanks to Tigeravatar & Dagindi, that works fantastic for ActiveX Combo Box to mimic the INdirect function in Data Validation. For generating dependant lists.
Private Sub ComboBox1_Change()
Me.ComboBox2.Clear
Dim ListCell As Range
For Each ListCell In Range(Me.ComboBox1.List(Me.ComboBox1.ListIndex))
Me.ComboBox2.AddItem (ListCell.Value)
Next ListCell
End Sub
However, It only works if the named ranges exist on the same worksheet. Does anyone know how to make the script work for named ranges on other worksheets?
Thankyou all in advance. The attached file shows the sample from Tigeravatar & Dagindi.
Bookmarks