Take a look at http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

wrote in message
ups.com...
Hi,

I am trying to create a combo box in excel with its contents based
upon an array.

i.e.
ARRAY:

Unit 1 | Unit 2 | Unit 3 | Unit 4
------------------------------------------
Result 1 | Result 2 | Result 3 | Result 4
Result 1 | Result 2 | Result 3 | Result 4
Result 1 | Result 2 | Result 3 | Result 4
Result 1 | Result 2 | Result 3 | Result 4

Question 1: Answer is Unit x
Question 2: Combo box is list of results based on values under unit x

Any thoughts?

Thanks