Hi Guys,

any ideas on this would be appreciated,

Im designing a form which will be a few list boxes that input data into specific cells in another sheet.

I would like the list boxes to change depending on selection.

eg: if there is a certain value selected in the first list, then only the relevant values will appear in the second box.


so if there are values Potato, Banana and Apple in list one, and list two contains values White, Yellow and Red.

if banana is clicked in list 1 then only yellow will appear in box 2 as a selection.



the only way i can think of doing it is with the list box linked to a group of cells which each contain a very long IF formula so if there are easier ways that would be great!

thanks