VBA QUESTION, dependant combobox on another combobox in Userform

[Kyletok]

I tried to google this, but didn't know how to word it properly so couldn't find a proper non complicated solution.

I have a table called 'Accounts' with all the account information.
Right now when I open the userform I have:

Private Sub UserForm_Initialize()
AccountBox.List = [Accounts].Columns(2).Value
End Sub

Which loads it with all the account numbers.

What if I had a combobox above it for Vendor?

VendorBox.List = [Accounts].Columns(1).Value

Can I somehow only show the accounts for the chosen vendor in AccountBox?
(I feel I am wording this wrong, can I filter it so it only shows the rows with the vendor?)

 

[Fluff]

How about

Private Sub UserForm_Initialize()
   Dim i As Long
   Dim Cl As Range
   
   For Each Cl In [Accounts].Columns(4).Rows
      If Cl.Value = "Name" Then
         Me.ComboBox1.AddItem Cl.Offset(, -3).Value
         Me.ComboBox1.column(1, i) = Cl.Offset(, -2).Value
         i = i + 1
      End If
   Next Cl
End Sub

 

[Kyletok]

How about

Private Sub UserForm_Initialize()
   Dim i As Long
   Dim Cl As Range
   
   For Each Cl In [Accounts].Columns(4).Rows
      If Cl.Value = "Name" Then
         Me.ComboBox1.AddItem Cl.Offset(, -3).Value
         Me.ComboBox1.column(1, i) = Cl.Offset(, -2).Value
         i = i + 1
      End If
   Next Cl
End Sub

That seems to do the trick! thank you so much I am very excited to start using it.

One thing, its not really an issue but if there's a fix I'd like to put it in.
When there is only 1 entry for an Analyst the combobox will include it with the second column the way it should, but for some reason theres a horizontal scroll bar, which doesn't appear otherwise.

Thanks again for all the help, this is going to help me a lot in building our reporting tool.

 

[Fluff]

You should only get the scroll bar if the values are greater than the width of the combo.

 

[Kyletok]

You should only get the scroll bar if the values are greater than the width of the combo.

theyre not, column 1 is :"Test Account" and column 2 is "Test",

this only occurs when there is only one account shown.

 

[Fluff]

I don't get that, if there is a scroll bar of 1 value in the combo, there is also a scroll bar if this is more than one value.
Check that you don't have any extra spaces for the 1 value.