dynamic Form List Boxes

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

ok guys sorry found the solution, using this formula in the cell reference

=INDIRECT(SUBSTITUTE($A$1," ","_"))

sorry to mess you round,

haven't actually found the solution i was looking for,

this formula is fine for data validation on a standard cell but not for form lists, any ideas again?

Hi

What sort of a "form" do you mean? A userform raised by a macro, or a place on the spreadsheet that is formatted to look like an input form?

rylo

hy rylo,

its one of the lists available on the "Forms" toolbar, alongside combo box and buttons?

thanks

Hi

Can you please attach an example copy of your workbook so we can see what you are struggling with.


rylo