By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,117 Members | 2,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,117 IT Pros & Developers. It's quick & easy.

Excel Dependent Lists on an Visual Basic form

P: 1
Good Afternoon

I have need of assistance for programming a visual basic form in excel.

In excel I have 3 named ranges
TM
Agents1
Agents2

In the TM range I have 5 different names of managers (ie Tom Smith, Bob Green, etc.)

In Agents1 I list the names of all the agents who are assigned to Tom Smith
In Agents2 I list the names of all the agents who are assigned to Bob Green

In VB I have a combobox named cbo.TM and cbo.Agents

If a person selects "Tom Smith" from the cbo.TM combobox I want the cbo.Agents combobox to be limited to the agents from Agents1 range in excel or if they select "Bob Green" from the cbo.TM combbox I want the cbo.Agents combobox to be limited to the agents from the Agents2 range.

If any of that is clear I would appreciate the assistance.

thank you in advance
evlpupy
Jan 4 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.