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:
Which loads it with all the account numbers.
What if I had a combobox above it for Vendor?
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?)
I have a table called 'Accounts' with all the account information.
Right now when I open the userform I have:
Code:
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?
Code:
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?)