Drop Down List:render a schematic

I'm pretty much in the same boat.

I'm using Excel to render a schematic for my Recording Studio.

I'm trying to set up the signal path of some of the wiring using Hyperlinks.

The challenge I'm facing is that I'm needing to place wiring conduit into the signal chain, and the conduit carries several wires. Which means that when I select the conduit in the schematic, I'm going to need a drop down list which provides for the selection of different signal path options and which ideally fires a Hyperlink automatically once selected.

So far I've determined that the Combo Box seems to provide the right visual representation, but linking the Drop Down list to Hyperlinks is still alluding me.



Any help would be appreciated.


Ian