List box to update another from excel

[Alex88]

Hi, I am currently creating a list box and updating it from a excel spreadsheet. What i would like to do is make a choice on that list which updates another list box, possibly from the same workbook just a different worksheet. So for example i have a list of products, say 4, of which i have a different sheet corresponding to each product with the avaliable tests i can do on it. So on the front screen you would choose your product and then choose your test depending on which product you choose. Any ideas? or is it easier to just use a tree and manually update it. I was thinking it would be a lot easier to update an excel sheet?

Thanks

Alex

[DAD]

Hopefully you're using events.  If so I'd use the value change event on the first list box to read the value, then pull the tests from the corresponding worksheet and populate the second list box with those values.

[Alex88]

Ok i will have a go at it. I am using events in a queued state machine architecture. Thank you for your help