View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Khaledity Khaledity is offline
external usenet poster
 
Posts: 12
Default Linking combo box to another

On Sep 11, 9:01*pm, ryguy7272
wrote:
It is quite easy to create a dependent list; look here for details:http://www.contextures.com/xldataval02.html

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''..



"Khaledity" wrote:
Hi,


Please I need to know how to link 1 combo box to another.


Example:
- I have a list of departments (Production, IT, HR, Finance), and a
list of job titles (all positions in the company)
- I want to see only relevant job titles when I choose a specific
department. i.e. when I choose HR department, I want to see only
relevant titles (Training Specialist, Recruitment Coordinator,
Compensation Analyst)


Please advise.


Thanks.


Khaledity- Hide quoted text -


- Show quoted text -


Thanks a lot, it was of great help. What if I want to do the same but
with combo boxes? is it doable?