conditional list in list box

[Reset]

Is there a way to have a conditional and updating list box? The list comes from another sheet column A, but I want the condition to only populate the list with values from column A if the corresponding cell in column B is blank. I run a macro where the selected items in the box will then get that cell in the second column filled in, thus the list box would decrease.

 

[Saagar]

You can use this code at the end of macro that fills in the second column.

This macro deletes all the entries in the list box ListBox1 and then parses column B from row 1 to 10. If it finds that the Column B is blank, it will add the corresponding value in Column A in to the list box.

ct = ListBox1.ListCount - 1

For i = 0 To ct
        ListBox1.RemoveItem (ct - i)
Next

For i = 1 To 10
    If Cells(i, 2) = "" Then
        ListBox1.AddItem (Cells(i, 1))
    End If
Next