PDA

View Full Version : Changing ListBox Range - From another ListBox



thombill
05-17-2006, 12:26 PM
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.

3157


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

Thank you in advance.

:banghead:

mdmackillop
05-17-2006, 01:08 PM
Hi,
Have a look at this solution http://www.vbaexpress.com/forum/showthread.php?t=7533
Regards
MD

thombill
05-17-2006, 01:16 PM
MD,

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

:friends:

geekgirlau
05-17-2006, 06:53 PM
Don't forget to mark this thread as "Solved" - go to "Thread Tools" at the top of the screen.