NIPUL JARIWALA
Board Regular
- Joined
- Apr 22, 2016
- Messages
- 55
I am using a combobox and need help
I want if perticular row(i) and column number 48(AV) ="" then combobox should not add item in list
here is my code
I want if perticular row(i) and column number 48(AV) ="" then combobox should not add item in list
here is my code
VBA Code:
Dim vList, d As Object, i As Long
vList = Sheet1.Range("C8", Sheet1.Cells(Rows.Count, "C").End(xlUp)).Value
Set d = CreateObject("system.collections.arraylist")
For i = LBound(vList) To UBound(vList)
If Not d.contains(vList(i, 1)) Then
d.Add vList(i, 1)
End If
Next
d.Sort
ComboBox29.List = d.toarray
Last edited by a moderator: