Need help with ComboListbox with 2 colums, 1 linkedcell, 4lists.
Hello.
Scenario:
Windows10, MS365
Xcel.
ComboListBox activeX
4 datalist in another page called: Data
1 linked cell
I try to list data from 1 of 4 diffrent lists, shown in 1 combolistbox (and its 2 columns)
Choices, shown permanent in 1st column
"DATA1"
"D...2"
"
"
all choices of string type
Lists:
List1 List2 List3 List4
Max 170 lines of data in each list or and better, use actual number of items in each lists
The linked cell is set to a free cell, containing name of choice choosen.
What I try to achieve is:
when data(stringtype) in free cell is altered, set listfillrange to proper List (1 of 4) which will, hopefully
show the content of list in column no 2 in the combolistbox :)
The code belw is surely, at its best, very poor as this is all new to me.
VB code
Private Sub ComboBox1_Change()
If ComboBox1.LinkedCell = "Skedsmo" Then
ComboBox1.ListFillRange = "Data(a2:a113)"
End If
End Sub
|