Hello everyone
I have a question on vba comboboxes.
I have two combo boxes fullfilled with the same list of names. When I pick a name on the list of Combo box 1, how can I automatically exclude the picked name from the list on combo box 2, keeping the remaining names?
I'm using the following code to populate combo boxes 1 and 2:
For i = 1 To WorksheetFunction.CountA(Columns("A:A"))
UserForm1.ComboBox1F.AddItem ActiveCell.Offset(i - 1, 0) & "-" & ActiveCell.Offset(i - 1, 1)
UserForm1.ComboBox2.AddItem ActiveCell.Offset(i - 1, 0) & "-" & ActiveCell.Offset(i - 1, 1)
Next i
Thanks in advance
I have a question on vba comboboxes.
I have two combo boxes fullfilled with the same list of names. When I pick a name on the list of Combo box 1, how can I automatically exclude the picked name from the list on combo box 2, keeping the remaining names?
I'm using the following code to populate combo boxes 1 and 2:
For i = 1 To WorksheetFunction.CountA(Columns("A:A"))
UserForm1.ComboBox1F.AddItem ActiveCell.Offset(i - 1, 0) & "-" & ActiveCell.Offset(i - 1, 1)
UserForm1.ComboBox2.AddItem ActiveCell.Offset(i - 1, 0) & "-" & ActiveCell.Offset(i - 1, 1)
Next i
Thanks in advance