Auto-updating dependent drop down lists

Hi All,

I'm brand new to this forum and joined because I've been searching for an answer to what I'm trying to do and haven't found something that really fits the bill. My problem is simple in theory, but seemingly not in application.

I created a lookup tool for searching data and it all works great. I even provided a set of "switches" (using simple on/off drop down lists) for a user to turn on and off the lookups under certain categories (to pull more or less data, depending on their needs). What I would like to do now is add a master switch, so the user can turn them all off (or back on) using this single switch rather than manually changing all of the other switches. I am able to get the individual drop down lists to only provide the option of "off" when the master switch is "off" and both "on" and "off" when the master switch is "on," but I can't find how to automatically update all of the switches to "off" upon switching the master switch to "off" while still maintaining the ability to individually switch the others to "off" while the master switch is "on."

I realize that I could hard code the lookups to first check the master switch, but that would of course add another conditional, and would make the individual switches misleading by not turning "off" automatically.

I'm not yet familiar with VBA, but if this is the the route to go I would appreciate some additional guidance in applying the proper coding. Thanks in advance.

-Kevin

UPDATE:

I was able to figure out the VBA code to automatically flip my single switches to "Off"/"On" after selecting "off"/"On" for the master switch, but I'm still faced with the challenge of allowing the single switches to be individually manipulated while the master switch is "On." Currenly, it's all on or all off (which is fine for "Off, but not "On"). Thanks - K.