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

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

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?

Try this at Debra's site:

http://www.contextures.com/xlDataVal10.html#AddCombo

Peter

"Khaledity" wrote:

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?

On Sep 11, 11:05*pm, Billy Liddel
wrote:
Try this at Debra's site:

http://www.contextures.com/xlDataVal10.html#AddCombo

Peter



"Khaledity" wrote:
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?- Hide quoted text -

- Show quoted text -

I have managed to do the linkage with data validation, but I am still
stuck with combo boxes!!!

Bob Phillips has just what you want with a workbook to download as well.

http://www.xldynamic.com/source/xld.Dropdowns.html

Read the page it is excellent. If there is any problem downloading the
workbook contact me



and I'll send you a copy.

Peter

"Khaledity" wrote:


I have managed to do the linkage with data validation, but I am still
stuck with combo boxes!!!

On Sep 12, 1:16*am, Billy Liddel
wrote:
Bob Phillips has just what you want with a workbook to download as well.

http://www.xldynamic.com/source/xld.Dropdowns.html

Read the page it is excellent. If there is any problem downloading the
workbook contact me



and I'll send you a copy.

Peter



"Khaledity" wrote:

I have managed to do the linkage with data validation, but I am still
stuck with combo boxes!!!- Hide quoted text -

- Show quoted text -

Hi Peter,

I couldn't download the file, also I have sent couple of emails but it
bouns back! Please advise.

Sorry the keyboard must have stuck.



Peter

"Khaledity" wrote:

On Sep 12, 1:16 am, Billy Liddel
wrote:
Bob Phillips has just what you want with a workbook to download as well.

http://www.xldynamic.com/source/xld.Dropdowns.html

Read the page it is excellent. If there is any problem downloading the
workbook contact me



and I'll send you a copy.

Peter



"Khaledity" wrote:

I have managed to do the linkage with data validation, but I am still
stuck with combo boxes!!!- Hide quoted text -

- Show quoted text -

Hi Peter,

I couldn't download the file, also I have sent couple of emails but it
bouns back! Please advise.

On Sep 12, 12:30*pm, Billy Liddel
wrote:
Sorry the keyboard must have stuck.



Peter



"Khaledity" wrote:
On Sep 12, 1:16 am, Billy Liddel
wrote:
Bob Phillips has just what you want with a workbook to download as well.

http://www.xldynamic.com/source/xld.Dropdowns.html

Read the page it is excellent. If there is any problem downloading the
workbook contact me



and I'll send you a copy.

Peter

"Khaledity" wrote:

I have managed to do the linkage with data validation, but I am still
stuck with combo boxes!!!- Hide quoted text -

- Show quoted text -

Hi Peter,

I couldn't download the file, also I have sent couple of emails but it
bouns back! Please advise.- Hide quoted text -

- Show quoted text -

Thanks Peter, please check your email.