Changing ListBox Range - From another ListBox

[thombill]

Help! I have tried to come up with a easy way to accomplish my task, have tried to use filters, conditional statements. Just can't get it to function.

Problem:

I have two lists of items (Column A) & (Column B). In Column A I have a list of 3 companies but each company is listed several times, Column B is a list of the account codes for the three companies. They are arranged in rows, so company A, B, and C have multiple account codes.

I am trying to have a list that my folks can select there company name and then in the next box only see their applicable account codes. I am trying to keep this simple.

I have attached an example of the accounts, just don't really know where to start.

Attachment 3157


Even a couple of ideas of a better direction would be appreciated.

Thank you in advance.

[mdmackillop]

Hi,
Have a look at this solution http://www.vbaexpress.com/forum/showthread.php?t=7533
Regards
MD

[thombill]

MD,

That is exactly what I was looking for, I was just stepping on my toungue trying to explain my problem. Thank you.

[geekgirlau]

Don't forget to mark this thread as "Solved" - go to "Thread Tools" at the top of the screen.