From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
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?
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.