Multiple Combo Box Question

[bobojen]

I am trying to add 2 combo boxes, that I need to relate to each other.
For example:

In ComboBox1(on sheet1) will have data from sheet2

Apple
Orange
Pear

When Apple is selected, then in ComboBox2(on Sheet1), I want info fro
Sheet3 relating to the ComboBox1 (eg:

Apple Orange Pear
McIntosh Tangerine Bosc
Delicious Juice Bartlet
Ida Clementine Asian)

to show up. I cannot put the info on Sheet2. I do not know how to us
the VBA functions. If anyone can help me, it would be greatl
appreciated. If you need any more info, please let me know

 

[Frank Kabel]

Hi
have a look at
http://www.contextures.com/xlDataVal02.html
for creating dependent validation listboxes

 

[Bob Phillips]

Bob,

I have an example workbook that shows linked comboboxes and linked DV s.
Mail me at bob . phillips @ tiscali . co . uk (remove the spaces) if you
want a copy.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)