Drop Down List:render a schematic

**IGWright** · 09-13-2007, 09:20 AM

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

**Greg M** · 09-13-2007, 09:52 AM

Hi there,

Could you use the HYPERLINK function to generate the hyperlink itself, and use the output from the combobox to generate the "link_location" argument of the HYPERLINK function?

Regards,

Greg M

**IGWright** · 09-16-2007, 08:08 AM

Hey Greg,

Thanks for jumping in. So if I'm to understand, use the Combo Box Drop Down as a part of the formula. Set the Combo box and then activate the Hyperlink.

I was looking for a VBA code that would simply fire when I made a selection on the Drop Down, but I've posted everywhere I could find, and even got banned from *zgrid "for life" for cross posting.

I've never written VBA myself and I'm probably not smart enough to learn how, so I think I'm gonna adobt your approach it does add an extra step, but I've got to get going on this stuff since I've stuck on the Drop Down Hyperlink thing for several days now.

Here I go.

Thanks,

Ian

Drop Down List:render a schematic

LinkBack

Thread Tools

Display

Drop Down List:render a schematic

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions