Combo Box Filtering

[ScottP4680]

I have a list of all possible things in one column (Let's say column A), and then in another column (let's make it non-adjacent, Column F), I have a list that has data populated in some rows (of column F), but not others. I want
the combo box to reflect only the things in Column A which have data in Column F.

My list in column A might be 40 items long, but only 3 or 4 of them actually have data populated in F. Is there a non-VBA way to do this? I don't want to have to scroll up and down through all 40 items in column A to get things in rows 2, 18, and 33 for every instance I'll be using.

I'm not really VBA literate (I can read it, and understand what's going on generally, but I couldn't write a module or command to save my life), but if that's the only way to do this, let me know. If whomever could maybe drop some code my way, I'd appreciate it. I know how to paste it into the sheet macros and VBA modules.

 

[My Aswer Is This]

What are you using the ComboBox for if you say you do not want to use Vba.
And why are you saying lets say column A and lets say column F

Why not be specific?
But try this if you want. I know of no way to do this without using Vba.

Private Sub CommandButton1_Click()
'Modified 2/21/2020 1:02:40 PM EST
Application.ScreenUpdating = False
Dim i As Long
Dim Lastrow As Long
ActiveSheet.ComboBox1.Clear
Lastrow = Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To Lastrow
If Cells(i, "F").Value <> "" Then ActiveSheet.ComboBox1.AddItem Cells(i, 1).Value
Next
Application.ScreenUpdating = False
End Sub

 

[ScottP4680]

Thanks for the help!

 

[My Aswer Is This]

Thanks for the help!

Glad I was able to help you.