I've got a dropdown selection of Cameras (Canon 5D, Canon 6D, Ursa Mini etc.) and I have a single list of possible frame sizes (1280x720, 1920x1080, etc.) and also a single list of possible frame rates (23.97, 24, 25 etc.). What I'm trying to figure out is if there is a way to make it so that when I select (for example) Canon 6D the "frame size" and "frame rate" dropdowns only include values which that camera supports (e.g. 6D does not support anything above 1920x1080 @30fps, but the Canon 5D supports 4k at 60fps)
I've seen how to create dependent dropdowns but all of them have used separated lists, which would mean (as I understood it) that I'd have to create a separate frame size and frame rate list for each camera. It's fine if that's the way I have to go but I'd rather cut down on the number of lists (the way I want to go seems more "elegant").
VBA is okay, but I'd prefer a method without (if such exists) as I'm going to be importing it to Google Sheets and I've had limited success with VBA moving from Excel to Google. :p
So, is this even possible?
Thanks in advance.
Bookmarks