|
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
| 
