the below link is very helpful for this. It's really difficlut to hass these
out on a board

www.xldynamic.com/source/xld.dropdowns.html

Jeremy

"Wackyracer" wrote:

I am trying to creat an ordering form that has several criteria/options that
have to be matched to allow other options.

I have a dropdown box that allows 4 options (1,2,3 or 4) and depending upon
which one is selected then nedd box needs to only show the next options
according the that number.

Dropdown box One Option 1
Dropdown box Two Option A or B

Dropdown box One Option 2
Dropdown box Two Option C or D

Dropdown box One Option 3
Dropdown box Two Option E F or G etc

I've setup the lists in another sheet in the workbook and have them named
but cannot work out how to link the 2 boxes/lists together.

Many thanks