Populating combo box based on which cells are empty

[Weasley0307]

Hi. I am beginner in vba. I want to have my a combo box in my userform to display all the list of entry (from Column C) based on which whichever cell in row A is empty.

For example: in this case below the combo box should display 202403 and 202405 since A6 and A8 are empty.

Can anyone guide me on how to write the code? Thanks

 

[Anthony47]

Try the following snippet:

For I = 5 To Cells(Rows.Count, "C").End(xlUp).Row
    If Cells(I, "A").Value = "" Then
        UserformName.ComboBox1.AddItem Cells(I, "C")            'Your userform name
    End If
Next I

For example use it within the userform.initialize code:

Private Sub UserForm_Initialize()
Dim I As Long
'
For I = 5 To Cells(Rows.Count, "C").End(xlUp).Row
    If Cells(I, "A").Value = "" Then
        Me.ComboBox1.AddItem Cells(I, "C")
    End If
Next I
End Sub

Try...

 

[Weasley0307]

Thanks Anthony. Works great!

 

[Anthony47]

Thank you for the feedback