I've got a general idea of how to build cascading comboboxes in Excel using lookups and VBA, but it's the end of the day and I'm brain-dead.
Can someone please post step-by-step instructions? You don't have to go into great detail; I've got the gist of it, but I'm goofing something up and I keep getting errors. Row1 contains headers, so the selection range starts with Row2.
When a Department is selected, I'd like the appropriate combobox list to appear so the user can select a Subdepartment from that list. For example, when the user selects Department 1 from a combobox, then the second combobox should contain Subdepartment1 selections (SubdeptA, SubdeptB, SubdeptC, and SubdeptD). Likewise, when Department 2 is selected, a combobox containing Subdepartment2 selections should drop down -- and so forth.
I think the problem might be in defining the range, or assigning a rowsource. Any help would be greatly appreciated!
That method is new to me, I wanted to go all VBA (but that's just me)
Maybe a tip (Shades, correct me if I am wrong): see if you can use lists to create the columns (each column a seperate list): why?
Lists are a sort of named ranges which you can add and delete items from. If doing so, your list's range will automatically scale with it. That means that you do not need to update the ranges when you add/remove a row of data.