Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with hyperlinks in pulldown list. Anyone know how?
In the example below, there is a list used as a pull down menu. The object is, when the pull down is used, the "list" consists of "comments" most commonly used in the Comments field of a report. Some of the entries in the list are actually hyperlinks. (The 1st 4 in the list below are hyperlinks) The pull down works fine. But when one of the hyperlinks is selected, it becomes normal text when it goes into the comment cell. What we want is for the customer to be able to go directly to the area of the spreadsheet with that specific information. There is no way to know in advance what comments will be needed in any particular row. It all depends on the data in the report. To save time, and automate as much as possible, there are "standard" comments, ones most commonly used. For example, if a particular row is for reporting "Position Deviation", (which might be row 27 in one report, lines 2, 12 and 34 in another, etc.) and if that Position Deviation exceeds tolerance, then there is a location in the spreadsheet for calculating Bonus Tolerance. So this particular comment might be . . . OK with Bonus Tolerance. Click Here to go to "Bonus Tolerance Calcs" As opposed to being a text line saying . . . OK with Bonus Tolerance. See "Bonus Tolerance Calcs" section This is an abreviated typical pull down list. 1 through 4 are supposed to be hyperlinks. In the actual reference list, the hyperlinks work fine. OK with Bonus Tolerance. Click Here to go to "Bonus Tolerance Calcs" See Min Max section below Click Here to go to "MinMax" See Normal Deviation section below. Click Here to go to "NormDev" Verified with Calipers: Click Here to go to "MinMax" Verified on Plate with indicator Verified with Calipers Verified with Mics See Profile Charts Tab Note: The entire line can be a link. It doesn't have to be just the "Click here". -- Wayne Knazek ------------------------------------------------------------------------ Wayne Knazek's Profile: http://www.excelforum.com/member.php...o&userid=35794 View this thread: http://www.excelforum.com/showthread...hreadid=555640 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
how to create multiple hyperlinks within a dropdown list | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |